Thread: Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu
Data Text to Columns Delimited Finish

"JBird11002" wrote:

Make formatted name in one column from "last, first MI" to three seperate
columns of: 1st col-First name"first", 2nd col-Middle"middleOrMI" and 3rd
col-Last name"last". When you have a file with several rows of names you
would like to do this to, how do you do it? Going through it individual row
by row would be time consuming and monotonous.
Reply With QuoteReply With Quote