Forum Discussion
Extracting Data from Free text
Greetings, We are trying to extract server names from our event logs that we exported to Excel. The following is an example of a cell which contains free text "Domain Controller Blocked Audit: Au...
If those are line breaks in the data, you could use this:
=LET(
delim, "Secure Channel name: ",
line_break, CHAR(10),
TEXTBEFORE(TEXTAFTER(A1, delim), line_break)
)
