View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chad[_3_] Chad[_3_] is offline
external usenet poster
 
Posts: 32
Default Separating information in a text string

If you are just importing names, can you imoprt them using a 'space'
seperator instead of a comma?


"Still learning@work" wrote in
message ...
I have imported information from an AS400 into an Excel spreadsheet. I
need
to separate the employee name field. Currently the name field is "Brown,
Oscar J". All names vary in length. What is the easiest way to split
this
into separate columns under Last Name, First Name, and Middle Initial?