Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

extracting variable text

Forum home » Delegate support and help forum » Microsoft Excel Training and help » EXTRACTING VARIABLE TEXT

EXTRACTING VARIABLE TEXT

ResolvedVersion 2010

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

Wed 11 Nov 2015: Automatically marked as resolved.

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.