Merging Two Columns & keeping data from both

[SheBear]

Hi everyone,

I am trying to merge two columns together with the data in both to merge.

eg. column1= s04
column2= 6458725

I want it mergerd to read:
s046458725

Is this possible?

cheers

 

[Aladin Akyurek]

On 2002-04-03 23:10, SheBear wrote:
Hi everyone,

I am trying to merge two columns together with the data in both to merge.

eg. column1= s04
column2= 6458725

I want it mergerd to read:
s046458725

Is this possible?

cheers

In C1 enter and copy down:

=A1&B1

 

[GaryB]

You could do it by a formula...
assuming your data is in columns A & B
=concatenate(A1,B1)
and then copy it down the column

HTH

GaryB