Is it possible to split a cell that contains a persons full name into 2 or three cells?
I am working on a database that has the names of people in one cell...I inherited this database...the end result is to have a first and last name at best (middle name not needed) so I can create a csv file to upload into my google contacts. I have about 675 rows of data. Is it possible to create a macro (which I know nothing about) to get this done quickly versus typing it all out?
Thank you!
Why do you need a macro?
Assuming that your data starts in A1, put this formula IN B1
=LEFT(A1,FIND(" ",A1,1)-1)
In C1, put this one.
=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))
Copy down.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
SOLVED!!!!
Found my answer so swift!!!
http://blogs.msdn.com/b/lauraj/archi...08/177965.aspx
It is the Text to Column command under data!!!!
you rock...I found an easier solution but yours works well You rock and thanks for quick response!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks