Combing Text From Different Cells

  • Thread starter Thread starter Freddy
  • Start date Start date
F

Freddy

I need to combine text data from different cells to create a part number.

E.g.

A1 = LSI
A2 = /
A3 = 15
A4 = /
A5 = BC

Want the value of A6 to be the sum of A1:A5 to generate a value of
LSI/15/BC.

Not sure how to do this. Any assistance is appreciated.
 
The formula is =A1&A2&A3&A4&A5

You could also do =A1&"/"&A3&"/"&A5 if you don't want to have to keep
entering slashes as cells.
 
Wed said:
I need to combine text data from different cells to create a part number.

E.g.

A1 = LSI
A2 = /
A3 = 15
A4 = /
A5 = BC

Want the value of A6 to be the sum of A1:A5 to generate a value of
LSI/15/BC.
Click to expand...

The & operator combines text. In A6 put
=A1&A2&A3&A4&A5
There's no way to do it with A1:A5, as far as I know: you have to
write out the five cell references.
 
Back
Top