LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 281
Default Formatting Columns

Hi,

Try this:

=A1&" "&B1
suppose First Names are in column A and Last Names are in column B.

Thanks,
--
Farhad Hodjat


"Jessica" wrote:

I have a spread sheet that someone else created. It has two columns one with
Last Name and the other with first name. I would like to combined both
together to make it into one without having to type all the names all over
again. What can i do?



 
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
Formatting Columns Aline Excel Discussion (Misc queries) 1 April 4th 07 08:44 AM
Columns formatting Maksko Excel Discussion (Misc queries) 2 February 2nd 07 09:42 AM
formatting columns by date JR Jen Excel Worksheet Functions 1 May 24th 06 06:30 PM
Formatting Columns wg100 Excel Worksheet Functions 3 October 26th 05 10:15 AM
Formatting and Grouping Columns Lisa Beach Excel Discussion (Misc queries) 0 October 6th 05 06:04 PM


All times are GMT +1. The time now is 02:25 PM.

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

About Us

"It's about Microsoft Excel"