| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separate figures from Text
Dear Mate,
I have some 1000+ data which has a mix of text and figues combined. Each combined entry is in one cell. I need to separate them or remove the figures from the text for examaple. 4357890Robetson & company 6578David Co. Ltd 1234bedrock ltd Regards Mat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| HOw do I merge two separate months of sales figures? | Excel Worksheet Functions | |||
| Separate cell text FirstnameLastname into two columns | Excel Discussion (Misc queries) | |||
| How do I keep cell color formats separate from text during A-Z sor | Excel Worksheet Functions | |||
| How do I convert figures to text? | Excel Worksheet Functions | |||
Threaded Mode
