PC Review


Reply
Thread Tools Rate Thread

Combining Columns Into One Column

 
 
Guest
Posts: n/a
 
      25th Jun 2008
If I have first name in one column and last name in another column how can I
combine the names together so they fit into one column?
 
Reply With Quote
 
 
 
 
Marcelo
Guest
Posts: n/a
 
      25th Jun 2008
first name in A1
second name in B1

on c1 use =B1&" "&B1


or concatenate(a1," ",b1)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Té" escreveu:

> If I have first name in one column and last name in another column how can I
> combine the names together so they fit into one column?

 
Reply With Quote
 
Guest
Posts: n/a
 
      25th Jun 2008
Thank you!!!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining 1 column into many columns =?Utf-8?B?SGVscCBAIFdvcms=?= Microsoft Excel Misc 4 4th Oct 2006 11:07 PM
combining separate columns into one column in a query John MilburySteen Microsoft Access Queries 2 16th Sep 2006 04:04 PM
Combining mutiple columns into one column noelcantona Microsoft Excel Worksheet Functions 1 16th Oct 2005 06:18 PM
combining 3 columns (year, month, day) into one column Lorraine Microsoft Excel Worksheet Functions 1 28th May 2004 12:36 PM
Merging or Combining 2 columns of data into 1 column Josh Microsoft Excel Misc 1 30th Sep 2003 09:31 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:33 PM.