| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Seperate cell string into individual cells
List of names: Cell A1: Sam A. & Sue R. Jones How can I seperate this string into individula cells? B1: Sam C1: A. D1: Sue E1: R. F1: Jones Thanks in advance for any assistance. Rudy -- ERudy ------------------------------------------------------------------------ ERudy's Profile: http://www.excelforum.com/member.php...o&userid=34365 View this thread: http://www.excelforum.com/showthread...hreadid=541415 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Seperate cell string into individual cells
Hi,
You can copy these words to txt file first. Then, use excel to open the txt file. Excel will give a 'Text File import wizard', pls choose the delimited with the Space Best Regards Seymon "ERudy" wrote: List of names: Cell A1: Sam A. & Sue R. Jones How can I seperate this string into individula cells? B1: Sam C1: A. D1: Sue E1: R. F1: Jones Thanks in advance for any assistance. Rudy -- ERudy ------------------------------------------------------------------------ ERudy's Profile: http://www.excelforum.com/member.php...o&userid=34365 View this thread: http://www.excelforum.com/showthread...hreadid=541415 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Seperate cell string into individual cells
Hi!
Try this: Make sure the columns to the immediate right of cell A1 are empty to be able to receive the parsed data. Select cell A1 Goto DataText to Columns Select Delimited Click Next Delimiters: Select space Click Finish Biff "Simon" wrote in message ... Hi, You can copy these words to txt file first. Then, use excel to open the txt file. Excel will give a 'Text File import wizard', pls choose the delimited with the Space Best Regards Seymon "ERudy" wrote: List of names: Cell A1: Sam A. & Sue R. Jones How can I seperate this string into individula cells? B1: Sam C1: A. D1: Sue E1: R. F1: Jones Thanks in advance for any assistance. Rudy -- ERudy ------------------------------------------------------------------------ ERudy's Profile: http://www.excelforum.com/member.php...o&userid=34365 View this thread: http://www.excelforum.com/showthread...hreadid=541415 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Need to convert text string to seperate cells | Excel Worksheet Functions | |||
| Using the results from two seperate cells to create cell reference | Excel Worksheet Functions | |||
Hybrid Mode
