Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help splitting text entries with commas
Hi all - I have a sheet of names in the format "-Last name, First name, team-", and I want to change the list to be "First name last name (no comma, no team)". I can't think of a simple way to do it? Is there a way to split text using a specific symbol (comma in this case) as the divider? I've been trying combos of "mid" with the "search" function to find the first comma. This has allowed me to extract the last name, but I'm having trouble getting the isolated first name... Thanks! -- andrewm27 ------------------------------------------------------------------------ andrewm27's Profile: http://www.excelforum.com/member.php...o&userid=25130 View this thread: http://www.excelforum.com/showthread...hreadid=535322 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help splitting text entries with commas
Hi
Use 'Text to Columns' feature from Data menu Arvi Laanemets "andrewm27" wrote in message ... Hi all - I have a sheet of names in the format "-Last name, First name, team-", and I want to change the list to be "First name last name (no comma, no team)". I can't think of a simple way to do it? Is there a way to split text using a specific symbol (comma in this case) as the divider? I've been trying combos of "mid" with the "search" function to find the first comma. This has allowed me to extract the last name, but I'm having trouble getting the isolated first name... Thanks! -- andrewm27 ------------------------------------------------------------------------ andrewm27's Profile: http://www.excelforum.com/member.php...o&userid=25130 View this thread: http://www.excelforum.com/showthread...hreadid=535322 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting data in a single cell that is seperated by commas, then moving to make individual rows | Excel Discussion (Misc queries) | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
sorting columns with more than 2 text entries | Excel Discussion (Misc queries) | |||
How can I do a "best match" for text entries? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |