| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separating a string to two fields
I have a full name column (Last, First) that I need to separate. I need the first name to move one column over. I was thinking about copying everything past the comma to one column over. If anyone could scribble out a macro for me, I would appreciate it! I'm really sorry for the simple nature of the question. I haven't used VB since college. Maybe someone has a 4 year old child that could help me out on this one! -- asdf032 ------------------------------------------------------------------------ asdf032's Profile: http://www.excelforum.com/member.php...o&userid=27041 View this thread: http://www.excelforum.com/showthread...hreadid=453971 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Separating a string to two fields
You are in luck. You don't need a macro. In the worksheet, just pull-down
Data Text to Columns... and let the wizard assist you. Good Luck -- Gary''s Student "asdf032" wrote: I have a full name column (Last, First) that I need to separate. I need the first name to move one column over. I was thinking about copying everything past the comma to one column over. If anyone could scribble out a macro for me, I would appreciate it! I'm really sorry for the simple nature of the question. I haven't used VB since college. Maybe someone has a 4 year old child that could help me out on this one! -- asdf032 ------------------------------------------------------------------------ asdf032's Profile: http://www.excelforum.com/member.php...o&userid=27041 View this thread: http://www.excelforum.com/showthread...hreadid=453971 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Separating a string to two fields
Thanks! That did it. I wish they had more delimiter options, but I ca deal with this -- asdf03 ----------------------------------------------------------------------- asdf032's Profile: http://www.excelforum.com/member.php...fo&userid=2704 View this thread: http://www.excelforum.com/showthread.php?threadid=45397 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Separating a string to two fields
With your list in Column A and nothing in Column B, select the list then use the menus DataText To ColumnsDelimited. Check comma and space and then click finish. Hope this helps Rowan -- Rowan ------------------------------------------------------------------------ Rowan's Profile: http://www.excelforum.com/member.php...o&userid=26535 View this thread: http://www.excelforum.com/showthread...hreadid=453971 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separating text into seperate fields | Excel Worksheet Functions | |||
| separating fields | Charts and Charting in Excel | |||
| separating fields | Charts and Charting in Excel | |||
| Separating Words From a Text String | Excel Programming | |||
| Test for char in string & separating if present | Excel Programming | |||
Hybrid Mode
