formula

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formula

Formula

resolvedResolved · Low Priority · Version 2016

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

Fri 2 Oct 2020: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips


Server loaded in 0.12 secs.