Need to create a text number from other columns

  • Thread starter Thread starter Sierra Mike
  • Start date Start date
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?
 
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
 
Back
Top