LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 71
Default Reversing Last Name and First Names

I have been given a spreadsheet with one column having approximately 1500
entries of First Name ( Some with Middle Initial ) Last name, in order to
upload this list into another program I need to have this one column become
two columns, one with all the first names and / initial if present, & the
second column with all the last names.

How do I do this without manually retyping all the names into the two new
columns?

 
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
REVERSING CELLS? FARAZ QURESHI Excel Discussion (Misc queries) 1 January 18th 07 07:19 PM
Reversing a column. How? [email protected] Excel Discussion (Misc queries) 5 December 21st 06 09:04 PM
Reversing First and Last Names excelnewbie Excel Discussion (Misc queries) 5 June 10th 05 03:59 PM
Reversing First & Last Name Magic Excel Worksheet Functions 3 April 6th 05 08:18 PM
reversing the sheet Moreken Excel Discussion (Misc queries) 1 March 29th 05 03:55 AM


All times are GMT +1. The time now is 12:32 AM.

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

About Us

"It's about Microsoft Excel"