Combining Functions: Text to Column & Replace

[tylergaps]

Hi all,

My company has recently implemented some live SMS notification system but I would like to input manually into excel for better overview tracking.
I am only able to come up with a basic 2 step process to enter this SMS data using Text to Column to break the "Alt + Enter" line breaks and then the Replace Function to remove the User/Date/Time/Error word leaving the details only before copying to a new row in a table. How do I improve this ?

Example of SMS Format
User: Tyler G
Date: 11/22/20
Time: 1122 HRS
Error: XX Department, Room XX , Machine XX

Desired output using the 2 step solution

User	Date	Time	Error
Tyler G	11/22/20	1122 HRS	XX Department, Room XX , Machine XX

 

[sparky2205]

If what you're looking for is just to split out what's before the colon and what's after the colon then this will work:
Before the colon: =LEFT(A1,FIND(":",A1)-1)
After the colon: =RIGHT(A1,LEN(A1)-FIND(":",A1)-1)

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff New.xlsm
	A	B	C	D	E
1
2	User: Tyler G Date: 11/22/20 Time: 1122 HRS Error: XX Department, Room XX , Machine XX	Tyler G	11/22/20	1122 HRS	XX Department, Room XX , Machine XX
InvDetails

Cell Formulas
Range	Formula
B2:E2	B2	=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A2,":", REPT(" ",100)),CHAR(10),REPT(" ",100)),COLUMN(A1)*200-99,100))