View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Still learning@work Still learning@work is offline
external usenet poster
 
Posts: 12
Default Separating information in a text string

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?