How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel?
I have several excel spreadsheets with user name fields in different formats as shown below. I need to extract the first and last names from the user names and fill them up in separate columns.
How do I do it? Plz. I am not familiar with excel queries or using ACL etc. I would truly appreciate detailed steps (or even syntax).....if it can’t be easily done in Excel, I would think we can just copy into word or download into any other database and slice & dice the data and copy it back into Excel spreadsheet……right?
I am in a time critical project and need to solve it asap. I will be checking responses every 10-15 mins. or so.
Thanks in advance!
Here's a sample of a column in excel that I have:
ARON JOELBECK - OASASI
Steve RIGHT - (Admin) Production Env.
DEBORAH A. LEWIS
Nancy (Diaz) Scott
Howard John - IS/GREY ST
Vickie Bosney Miami Tax Dept
Cindy Black-Miami Tax Dept
AbbottR@MSAD_NA
NA\Sherryl Batman
And, here's the output I would like to see
(Plz. note: The first and last names have to be in separate columns, and also the first letter in caps and rest small letters)
Aron Joelbeck
Steve Right
Deborah Lewis
Nancy (Diaz) Scott
Howard John
Vickie Bosney
Cindy Black
Abbot R
Sherryl Batman
Thanks for your help!
|