Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating Text From Numbers
Hi,
Does anyone know the formula to separate text from numbers? I tried applying the formula from an earlier post here (=LEFT(A1,LEN(A1)-B1) =RIGHT(A1,LEN(A1)-B1+1) but it didn't work for me. Did I miss something? Any help you can provide is greatly appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
separating numbers from a alphanumeric cell | Excel Worksheet Functions | |||
separating +ve and -ve numbers into two columns | Excel Discussion (Misc queries) | |||
Help - Separating numbers appearing on the right of a text string | Excel Worksheet Functions | |||
separating numbers and letters from alphanumeric cell contents | Excel Worksheet Functions | |||
Separating Numbers | Excel Worksheet Functions |