Text Extraction

[MrDB4Excel]

During the course of extracting the date and time data from this Excel sheet into a word document it adds a tab character between 2020, the @ and the time, in this case, 11:40.
So I first tried using the concatenate but it inserts numbers instead of date and time formats. Changing the format of the formula result into date and time does nothing. Then I tried extracting the numbers left of and right of the @ and set those formula results to date and time formats respectively and still nothing.
What I am trying to accomplish is to when I copy the three cells, in this case, E4, F4, and G4 together and paste together in Microsoft Word 2013 I want the tab characters to be replaced with 2 dashes (--) which is what I ultimately have to do in word using the replace feature, as seen in this third image.

If one or more formulas could auto-input into one cell the data from E4, F4, and G4 and insert the double dash between the date, @, and time that would be awesome.
Thanks for any help provided.

 

[GraH]

Hi,

The data and time in columns E/G are only formatted as data and time, the content is always a number.
Concatenation like you want can be done by forcing a conversion to Text and apply a correct format:
=TEXTJOIN(" ",FALSE,TEXT(E4,"ddd dd/mmm/yyyy"),F4,TEXT(G4,"hh:mm"))
or = TEXT(E4,"ddd dd/mmm/yyyy")&" "& F4&" "&TEXT(G4,"hh:mm")

EDIT: to have weekday appear like "Sat", you might need to tweak LEFT(TEXT(E4,"dddd"),3) & " " & TEXT(E4,"dd/mmm/yyyy")

 

[jasonb75]

This should do as you need without extra columns.

The List.xlsx
	E	F	G	H
2	02/05/2020		11:40	Message received Sat 02/May/2020--@--11:40
Sheet7

Cell Formulas
Range	Formula
H2	H2	="Message received "&TEXT(E2+G2,"ddd dd/mmm/yyyy--\@--hh:mm")

 

[GraH]

That's a cool trick I did not know.

 

[MrDB4Excel]

This should do as you need without extra columns.

The List.xlsx
	E	F	G	H
2	02/05/2020		11:40	Message received Sat 02/May/2020--@--11:40
Sheet7

Cell Formulas
Range	Formula
H2	H2	="Message received "&TEXT(E2+G2,"ddd dd/mmm/yyyy--\@--hh:mm")

Excellent formula, works beautifully, exactly what is needed.
Stay safe