Heather has attended:
Excel Intermediate course
EXTRACTING VARIABLE TEXT
I HAVE A FAIRLY LARGE VOLUME OF TEXT THAT I JUST WANT TO EXTRACT PART OF. E.G 'Deliveries - DAL'.
THE FIRST PART OF THIS TEXT IS ALWAYS 'Deliveries - '
IT IS THE LAST PART OF THE TEXT I NEED 'DAL'. THIS IS THE VARIABLE PART OF THE TEXT
PLEASE ADVISE IF POSSIBLE
THANKS
RE: EXTRACTING VARIABLE TEXT
Hi Heather,
Thank you for the forum question.
To extract text from a text string Excel offers a number of text functions.
If you have the text string "Deliveries - DAL" in A1 and want to extract "DAL" in B1. In B1 type:
=RIGHT(A1,LEN(A1)-13)
If it is alwas three characters you want to extract from the right type:
=RIGHT(A1,3)
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector