| Home |
| Search |
| Today's Posts |
|
#5
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 |
| 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) | |||
Threaded Mode
