| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
LEFT function
I have a list of extension numbers - some begin with 1 - I wish to have a
column that shows "Ignore" against the numbers beginning with 1. I thought the following formula would work: =IF(LEFT(A1,1)=1,"Ignore",A1) It looks like excel does not recognise the result from LEFT(A1,1)as 1 ? Thanks Andrew |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
| The left function does not work when displaying times, how is thi. | Excel Worksheet Functions | |||
| Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| left worksheet function within a combo box | Excel Worksheet Functions | |||
Threaded Mode
