Need to create a text number from other columns

S

Sierra Mike

I have text numbers in columns C, D, E, F and G. Total of 15 digits split
5-2-4-1-3. In column A, I want to create a 15 digit text number that reads
those 15 digits from the five columns. How do I do this?
 
F

FSt1

hi
use concantenators.
=C1 & D1 & E1 & F1 & G1
there is also a built in function
=CONCANTENATE(C1,D1,E1,F1,G1)

either way. the first is less typing.

Regards
FSt1
 

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

Top