Extract a portion of text
Hi.
For the life of me, I can’t work out the formula to extract a portion of text before and after a text delimiter.
Column A – First part of text in cell only – SOLVED
Column B – Raw Data
Column C – Require the second part of the text only. – UNSOLVED
For example from row 2
A2 B2 C2
IA20240429001294 Raw Data Bateau Bay
Any help would be very appreciated before i loose all of my hair!!
Hi.For the life of me, I can’t work out the formula to extract a portion of text before and after a text delimiter.Column A – First part of text in cell only – SOLVEDColumn B – Raw DataColumn C – Require the second part of the text only. – UNSOLVED For example from row 2A2 B2 C2IA20240429001294 Raw Data Bateau Bay Any help would be very appreciated before i loose all of my hair!! Read More