Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-18-2012, 11:15 AM
mag mag is offline How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? Windows 7 64bit How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? Office 2010 64bit
Novice
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel?
 
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
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? PowerPoint 2010 Pie Chart Animation Query theapcoach PowerPoint 2 05-04-2012 12:58 AM
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft