Concatenate 4 cells

  • Thread starter Thread starter Dgwood90
  • Start date Start date
D

Dgwood90

I need to combine 4 cells into 1

G6 = Technicians name
G7 = number of items
G8 = Date
G9 = assigned location

The result I would like to have is
John Doe_6_mm_dd_yyyy_1234567
This string eill then be used to save the file
 
Dgwood90 said:
The result I would like to have is
John Doe_6_mm_dd_yyyy_1234567
Click to expand...

=G6 & "_" & G7 & TEXT(G8,"\_mm\_dd\_yyyy\_") & G9

If G9 is less than 7 characters and you always want 7 characters, replace G9
above with TEXT(G9,"0000000").


----- original message -----
 
Back
Top