Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns Problem
Hi,
I am using Office 2K7 and facing a problem in splitting the text into different columns. I have lastnames and firstnames together in a cell and there is no such delimiter between them which can be identified by a single way that the last name starts with a Upper letter only. e.g. CandyRachel . I need to separate it into two different columns as 'Candy' and 'Rachel'. I think this is possible using Char function but not able to find out the way. Any help will be appreciated.. Thanks in advance.. Miki |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem with Data|Text to Columns | New Users to Excel | |||
Text to Columns Problem | Excel Discussion (Misc queries) | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
Text to columns macro problem | Excel Discussion (Misc queries) | |||
Linking text columns with text and data columns | Excel Worksheet Functions |