| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
separation of text and numbers in an unmerged cell
Supply some example of your data and how you want to seperate these items.
Text to column May work if you choose the delimted option, then hit next and selected spaces. "Tazeem" wrote: How exactly text and numbers can be separated in an unmerged cell. There is not a fixed number of digits in the available data so 'Text to column' option does not work. Please help. Thanks & Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i split an unmerged cell in two? | Excel Discussion (Misc queries) | |||
| Retain value of merged cell in all unmerged cells | Excel Discussion (Misc queries) | |||
| Imported text separation problem | Excel Discussion (Misc queries) | |||
| select first cell in unmerged range | Excel Discussion (Misc queries) | |||
| text and number separation | Excel Discussion (Misc queries) | |||
Threaded Mode
