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