View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JBird11002 JBird11002 is offline
external usenet poster
 
Posts: 2
Default Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu

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.