Formula

[bsepelak]

Number	Material	Batch
01	04.333.420	202817
02	04.334.565	204258
03	03.127.016	H800695-01

Is there a way to take these columns and format them to 01_04.333.420_202817?

[#2]

@bsepelak 

Let's say the data are in column A to C, starting in row 2.

Enter the following formula in D2:

=TEXT(A2,"00")&"_"&B2&"_"&C2

Fill down to the last row with data.

[#3]

Thank you so much for the help. there is a space between the .420 and the last _. Is there a way to get rid of that?

[#4 · Accepted solution]

@bsepelak 

That suggests that the cells in column B might contain a trailing space. To remove it:

=TEXT(A2,"00")&"_"&TRIM(B2)&"_"&C2

[#5]

Perfect, you just saved me hours of work! Thank you so much!