Merging Information

  • Thread starter Thread starter Pheng
  • Start date Start date
P

Pheng

Hi all,

I would like to merge information from two cells into one:

Example

A1=Product Code
B1=Model

NOTE: Each column has the same amount of rows

Can I copy the entire column from B1 and bring it together in colomn A1
WITHOUT overwriting the information in colomn A1???

Cheers,
 
Hi

you can't do it directly into column A without using code, you can however,
do it in column C and then copy (& edit / paste special - values) that over
A.

in C1
=A1&B1
if you want it to look like this
Product CodeModel
or
=A1& " " & B1
if you want it to look like this
Product Code Model
or
=A1& " - " & B1
Product Code - Model

then copy down (move cursor over bottom right corner of c1 until you see a +
and double click)
then select column c & copy it
click on A1 and choose edit / paste special - values
to replace A with the combined data

Cheers
JulieD
 
Back
Top