Vincent has attended:
Excel Intermediate course
Formula
we discussed at the end how to program a formala where the cell data is 8-11 characters, and we want to extract only character 5 and 6
RE: 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
