Excel jiggery-pokery

[DaveB]

Will the last test of the first line always be "(Customer Updates)" ? (or maybe even just " Updates)"

This is dirty, and strips out the date/time/etc on the first line... but works:
=MID(A1,FIND("Updates)",A1,1)+9,(FIND("-20",A1,10)-FIND("Updates)",A1,1))-15)

This will work for any year in the 21st century as long as "-20" and "Updates)" don't appear in the free text

or, if you want to include the date & name:
=LEFT(A1,(FIND("-20",A1,10))-6)

This will work for any year in the 21st century as long as "-20" doesn't appear in the free text of the most recent comment.

Might try to refine it some more.

Do need the date and timestamp.

=LEFT(A1,(FIND("-20",A1,10))-6)

This works, but breaks if there is only one entry, which I hadnt thought about as there was only actually one row where that was the case.

[WTFH]

=LEFT(A1,IFERROR(((FIND("-20",A1,10))-6),LEN(A1)))

Gets round the bug in version 1.
The IFERROR function returns the value if it gets a match, if it doesn't get a match (i.e. goes into error) then it returns the length of the cell

[DaveB]

=LEFT(A1,IFERROR(((FIND("-20",A1,10))-6),LEN(A1)))

Gets round the bug in version 1.
The IFERROR function returns the value if it gets a match, if it doesn't get a match (i.e. goes into error) then it returns the length of the cell

Bingo!

I owe you a pint