Formula

Hi Vincent,

Thank you for the forum question.

If you want to extract character 5 and 6 you can use the Mid function.

=MID(text, start_num, num_chars)

The first argument "text" is the cell reference in which you have the text. "start_num" is a number from where you want to extract the characters from. In your case 5. "num_chars" is 2 in your example. Your want to extract 2 characters starting from character 5.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
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