Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
andrewm27
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Arvi Laanemets
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Splitting data in a single cell that is seperated by commas, then moving to make individual rows [email protected] Excel Discussion (Misc queries) 2 April 3rd 06 10:44 AM
How change dimensions of data label text box in pie chart? Gouden Willem Charts and Charting in Excel 3 March 7th 06 01:11 PM
sorting columns with more than 2 text entries J Blumenthal Excel Discussion (Misc queries) 2 September 29th 05 05:13 AM
How can I do a "best match" for text entries? NeedDataHelp Excel Worksheet Functions 1 February 25th 05 01:27 AM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 01:37 AM


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"