Merging Two Columns & keeping data from both

SheBear

New Member
Joined
Apr 2, 2002
Messages
1
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
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,562
Messages
6,114,322
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top