Hi There. I was given a speadsheet that contains multiple lines of text in one cell. See below for an example.
A1
IB008
IT003
IT135
Is there a formula I could use where I would be able to extract any text that begins with "I". So in this instance, the output would be:
A1 B1 C1
IB008 IT003 IT135
IT003
IT135
Thanks!
Bookmarks