| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seperate Alphabet and numbers in a cell
Hi,
Well I tried to seperate alphabets and numbers from a single cell but it has to be done manually, the example of my data is "123456 klm" , "1294535 PTY", "00000000018956 MO7 Payment Recived". I have almost 10000 enteries of such data. Thanks for your concern. K****ij |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I seperate numbers from text (in one cell) into 2 cells? | Excel Discussion (Misc queries) | |||
| Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) | |||
| associate alphabet letters with numbers? | New Users to Excel | |||
| alphabet as Numbers? | Excel Discussion (Misc queries) | |||
| SEPERATE NUMBERS IN A CELL | Excel Worksheet Functions | |||
Threaded Mode
