I need to add text from 2 columns in 1

  • Thread starter Thread starter skuba
  • Start date Start date
S

skuba

Hi,
This is my first message here. Could you guys help me?

I need to add text from 2 different columns together.
For instance:
one colums has value=part1
other colum has value=part2

Is there a way I can add or merge both values and make it look no
like=part1part2 ??????

When I try merging the cells I know it doesn't work. Is there anothe
way?

Thanks a lot for helping
 
skuba,

If "part1" is in Cell A1 and "part2" is inCell B1 the formula in Cel
C1 shoudl be "=A1&B1"

Regards

Seamu
 
Hi
enter the following formula (e.g. in C1 if A1 and B1 contain your part
strings):
=A1 & B1
copy this down
 
Back
Top