CONCATENATE TWO COLUMNS

T

The Cable Guy

Trying to concatenate two columns

eg
column 1 column 2
1234 2nd st
2345 3rd st
3456 4th st
4567 5th st
 
F

Fred Smith

Have you tried the concatenation operator, as in:
=a1&a2

Or the Concatenate function:
=concatenate(a1,a2)

Regards,
Fred
 
T

T. Valko

I assume you want a space between the cell values...

=A1&" "&B1

Returns: 1234 2nd st

Copy down as needed.
 
R

Rick Rothstein

Assuming Columns 1 and 2 are Columns A and B, put this formula in a third
column and copy down as needed...

=A1&" "&B1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to custom format a date 5
Remove Identical words 0
Find product from date range 5
match formula needed 2
Splitting Text from single cell in column across multiple Columns 3
Macro or Function 7
How to add a leading space to an existing text field? 1
How do I combine the contents of two columns? 4

Top