| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separate a FirstLast text string into two columns
Please advise on how to separate a text string that has no delimiters? The cells contain names without spaces or commas in this format: FirstnameLastname. The result I want is two columns with firstname in one and lastname in the second column. The only thing distinguishing the two desired fields within the string is an upper case letter at the beginning of first and last names. Thanks! :) -- drewannie ------------------------------------------------------------------------ drewannie's Profile: http://www.excelforum.com/member.php...o&userid=36079 View this thread: http://www.excelforum.com/showthread...hreadid=558657 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TEXT TO COLUMNS WITH LEADING ZEROS | Excel Discussion (Misc queries) | |||
| Converting Text String to Separate Numbers | Excel Discussion (Misc queries) | |||
| Find & Replace text format | Excel Discussion (Misc queries) | |||
| Turn Off Text To Columns | Excel Discussion (Misc queries) | |||
| Text to Columns from drop down list update | Excel Discussion (Misc queries) | |||
Threaded Mode
