merge or combine columns

[Lee Beck]

Is there a way to combine columns? I have a spreadsheet
with a couple thousand rows. I want to give each row a
unique identifier that has the components of a key number
(a 4-digit identifier). Some of the key numbers are the
same.

I decided to simply add a row of sequential digits 1-2000
and merge that column with the key number:

column A = 1
column B = -
column C = 2567
Merged column = 1-2567

Is there a way to do that?

Thanks

 

[Eva Shanley]

Hello,
There may be other ways, but you could use the formula
=A1&B1&C1 in cell D1 to get the result you want.

 

[Rita Palazzi]

try this
=concatenate(A1,B1,C1)

 

[Freemini]

One way
=A2&B2&C2
or =A2&"-"&C2

hth

Mik

 

[Mike Lewis]

This formula will do it:

=CONCATENATE(A1," - ",C1)

Good Luck

 

[Guest]

That works!!

Thanks, I had seen the concateneate command but didn't
know (or had forgotten) what it does.

Thanks again!