| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to separate text and numbers in one cell or column?
Hi,
I have a column of cells which are in any of the following formats: x # x x # x x x # where x could be any number of characters (a-z or A-Z) either upper or lower case. # could be a 1,2 or 3 digit number 0-9 I generally have to post process this file in UNIX before I import it into excel and do some modifications. Is there an easier way to do this in Excel? I don't mind copying the column and post processing one column to retain numbers and another column to retain text. -- novastar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to separate text and numbers | Excel Discussion (Misc queries) | |||
| move text & numbers in column to separate columns | Excel Discussion (Misc queries) | |||
| Separate Text into numbers and alphabets | Excel Worksheet Functions | |||
| how do i separate numbers and text in a cell? | Excel Discussion (Misc queries) | |||
| How to separate numbers from text?? | Excel Discussion (Misc queries) | |||
Threaded Mode
