=IF(D2="?0????",D2,LEFT(D2,3)) why dosen't it work

J

JQ

I am trying to find a string of charetors where the second cherecter is a
zerro and then either leve it or return three cherecters.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repost - Functions on filtered data 0
Imposs? Speed up 1
Working day(s)/Time between two dats (No Weekend or Holidays) 0
LEFT(D2,3) but no spaces 4
Help requested for nested conditional formulas referencing other c 3
Enter carriage return in Excel 2010 text string 2
Need a ) somewhere in ISERROR formula but don't know where to put it 3
Can I use an IS function with Vlookup 2

Top