Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 226
Default How to combind to cell with a <space

I have two columns with a first name in one and the last name in the other, I
would like to combined them into one column, what the best way to do this?
thx
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,089
Default How to combind to cell with a <space

=A1 & " " & B1 in cell C1, for example and drag down

Regards

Trevor


"Roger" wrote in message
...
I have two columns with a first name in one and the last name in the other,
I
would like to combined them into one column, what the best way to do this?
thx



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
space in cell wood1e Excel Discussion (Misc queries) 3 August 19th 06 09:05 AM
reformat a cell from last name, first to first space last? Shannon Excel Discussion (Misc queries) 5 June 24th 06 07:04 PM
Don't allow a space in a cell...how to prevent? Jugglertwo Excel Discussion (Misc queries) 2 December 2nd 05 04:50 PM
White Space in a Cell Gina O'Brien New Users to Excel 2 June 17th 05 03:02 PM
Removing a space within a cell JERRY8 Excel Worksheet Functions 3 December 2nd 04 03:22 AM


All times are GMT +1. The time now is 10:30 AM.

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"