| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I seperate numbers from text (in one cell) into 2 cells?
Hi Everyone
I have data in this form in ONE CELL 20040 - Selling Expenses I would like this data in TWO cells: [ 20040 ] [ - Selling Expenses ] Is there anyway to do this for a lot of cells? I use Vlookup a lot and Find/Replace and I imagine it could be done with wild characters maybe (?) but I do not have enough experience for this kind of search. Any suggestions appreciated! thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can i combine text from seperate cells into a sinle cell | Excel Discussion (Misc queries) | |||
| How to seperate a text group in once cell into many cells | Excel Discussion (Misc queries) | |||
| Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) | |||
| SEPERATE NUMBERS IN A CELL | Excel Worksheet Functions | |||
| Need to convert text string to seperate cells | Excel Worksheet Functions | |||
Threaded Mode
