Concatenate 4 cells
 

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

Concatenate 4 cells
 

"Dgwood90" wrote:
The result I would like to have is
John Doe_6_mm_dd_yyyy_1234567

=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 -----

"Dgwood90" wrote:
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

Concatenate 4 cells
 

Works exactly as I was wanting, Thanks!

"Dgwood90" wrote:

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