#1   Report Post  
 
Posts: n/a
Default IF function?

In column A I have a list of full names (first and last names). How can
I break up the full names so that the first names appear in column B
and the last names appear in column C?

  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Make sure B is empty, select A, do datatext to columns delimited, select
the delimiter maybe space or comma (whatever that separates the names), then
click finish. This will give you the first names in A and the last names in
B, if you want to keep the original column just make a copy and put in B,
the follow the instructions from above

--
Regards,

Peo Sjoblom

(No private emails please)


wrote in message
ups.com...
In column A I have a list of full names (first and last names). How can
I break up the full names so that the first names appear in column B
and the last names appear in column C?


  #3   Report Post  
 
Posts: n/a
Default

That worked! Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date & Time mully New Users to Excel 4 May 23rd 05 11:56 AM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM
Need a ISWorkday Function -- Any Ideas Mark Excel Worksheet Functions 5 March 29th 05 01:58 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM


All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"