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?
|