Need a transfer formula.

[serge]

Hi,
I'm looking for a formula that will transfer those cells data into 1 cell with 1 space between the date and the first digit and separated by a (-) between the 2 other digits.
Thank you.

Excel Workbook
	B	C	D	E	F	G
2	10/20/2017	5	3	0		10/20/17 5-3-0
Sheet

 

[Marcílio_Lobão]

serge, Good evening.

Try to use:

G2 --> =TEXT(B2,"MM/DD/YY") & " " & C2 & "-" & D2 & "-" & E2

Is that what you want?
I hope it helps.

 

[serge]

Thank you Marcilio, that exactly what I needed, Appreciate it.
Serge.

 

[Marcílio_Lobão]

serge, Good morning.

Glad to have helped you.


Have a good Sunday!