JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 567
- Office Version
- 365
- Platform
- Windows
I have this data starting in A1. I need to copy the text after the "xx" but not every line with start with "xx". Need formula to take text after "xx" if there, if not just need the text.
xx ABCDEFGHI trying to get ABCDEFGHI
JKLMNOPQR trying to get JKLMNOPQR
xx 12345678 trying to get 12345678
STUVWXYZ trying to get STUVWXYZ
Thanks,
James
xx ABCDEFGHI trying to get ABCDEFGHI
JKLMNOPQR trying to get JKLMNOPQR
xx 12345678 trying to get 12345678
STUVWXYZ trying to get STUVWXYZ
Thanks,
James