- Jan 29, 2004
- Office Version
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.