Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-18-2012, 11:15 AM
mag mag is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2012
Posts: 11
mag is on a distinguished road
Thumbs down 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!
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 09:37 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft