Combing Text From Different Cells

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.
 
J

jbromberek

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.
 
S

Stan Brown

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blank Cells 3
if the numbers in sequence 11
Multiple If statemnets 9
Sum number range ignoring numbers formatted as text 0
Average Question 2
Macro to add Multiple rows in same sheet 1
Not so simpel copying of a simple formula 5
Combining Text From Cells 3

Top