| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with manipulating text in Excel 2003
I have a column which is in the format of "Lastname, Firstname
textidonotcareabout". I'd like to change the text to Firstname Lastname via a function. Is this possible? If not then I'm trying to learn some basic VBA programming so a macro could be an option. Thanks in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with manipulating text in Excel 2003
Try using Data--Text-to-Columns... then go to Delimited and select space.
Other then that I know functions to switch last and first names but not with extra data involved. "Big UT Fan" wrote: I have a column which is in the format of "Lastname, Firstname textidonotcareabout". I'd like to change the text to Firstname Lastname via a function. Is this possible? If not then I'm trying to learn some basic VBA programming so a macro could be an option. Thanks in advance! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with manipulating text in Excel 2003
With data in A1, first find the first space, in B1 enter:
=FIND(" ",A1,1) To find the second space, in C1 enter: =FIND(" ",A1,B1+1) Finally in D1: = MID(A1,B1,C1-B1+1) & LEFT(A1,B1-2) -- Gary''s Student - gsnu200778 "akphidelt" wrote: Try using Data--Text-to-Columns... then go to Delimited and select space. Other then that I know functions to switch last and first names but not with extra data involved. "Big UT Fan" wrote: I have a column which is in the format of "Lastname, Firstname textidonotcareabout". I'd like to change the text to Firstname Lastname via a function. Is this possible? If not then I'm trying to learn some basic VBA programming so a macro could be an option. Thanks in advance! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with manipulating text in Excel 2003
On Wed, 9 Apr 2008 10:38:01 -0700, Big UT Fan
wrote: I have a column which is in the format of "Lastname, Firstname textidonotcareabout". I'd like to change the text to Firstname Lastname via a function. Is this possible? If not then I'm trying to learn some basic VBA programming so a macro could be an option. Thanks in advance! Perhaps: =LEFT(TRIM(MID(A1,FIND(",",A1)+1,255)),FIND(" ",A1)) & TRIM(LEFT(A1,FIND(",",A1)-1)) --ron |
|
#5
|
|||
|
|||
|
Quote:
http://www.cpearson.com/excel/FirstLast.htm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text wrapping in Excel 2003 | Excel Discussion (Misc queries) | |||
| Training on Manipulating Data in Excel | Excel Discussion (Misc queries) | |||
| Manipulating Text between sheets, in a workbook | Excel Discussion (Misc queries) | |||
| Where is text to speech in excel 2003? | Excel Discussion (Misc queries) | |||
| Text not copying as text from Word to Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
