| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement for alpha numeric combo AND numeric only
I need a formula that will strip out an alpha from a number:
B1=12,562.25CR B2=25,235.44 I want one formula in column C that will do two things. 1) if there is a CR, take it off and multiply the remaining value by (-1) =LEFT(B1,SEARCH("cr",B1)-1)*(-1) 2) if there isn't a CR, just give me the value in that cell the expected results for the above would be: C1= -12,562.25 C2= 25,235.44 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alphanumeric Sorting - numeric alpha numeric | Excel Worksheet Functions | |||
| How do I copy numeric section of cell from alpha-numeric cell | Excel Worksheet Functions | |||
| Alpha Numeric tab not showing only numeric. | Excel Worksheet Functions | |||
| only extract numeric value from alpha numeric cell | Excel Discussion (Misc queries) | |||
| The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) | |||
Threaded Mode
