Need to create a text number from other columns
 

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?

--
Sierra Mike

Need to create a text number from other columns
 

In A1 enter:

=C1 & D1 & E1 & G1 and copy down
--
Gary''s Student - gsnu200767


"Sierra Mike" wrote:

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?

--
Sierra Mike

Need to create a text number from other columns
 

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

"Sierra Mike" wrote:

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?

--
Sierra Mike