|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to prevent security alert when Excel doing web query from https web site? | johnsmith21 | Excel | 0 | 06-14-2012 01:16 PM |
PowerPoint 2010 Pie Chart Animation Query | theapcoach | PowerPoint | 2 | 05-04-2012 12:58 AM |
Need an Automated sql query for the Excel file | Karthick | Excel | 3 | 12-20-2010 04:52 AM |
Ofice 2010 LDAP query on Workgroup Network? | PeteMSDN | Office | 0 | 11-23-2010 10:12 AM |
Text Box Query | Meljord | Word | 3 | 12-15-2009 12:25 PM |