articles

Home / DeveloperSection / Articles / MID, MIDB functions in Excel

MID, MIDB functions in Excel

AVADHESH PATEL5574 28-Mar-2013

In this article I have described about the MID and MIDB function in Microsoft Excel.

 MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify. In other hand MID always counts each character, whether single-byte or double-byte, as 1, no matter what the default language setting is. 

Syntax

MID(text, start_num, num_chars) 

MIDB returns a specific number of characters from a text string, starting at the position you specify, based on the number of bytes you specify. In other hand MIDB counts each double-byte character as 2 when you have enabled the editing of a language that supports DBCS (double-byte character set) and then set it as the default language. Otherwise, MIDB counts each character as 1. 

Syntax

MIDB(text, start_num, num_bytes)

 

MID, MIDB functions in Excel


Updated 07-Sep-2019
Avadhesh Kumar Patel District Project Manager - Aligarh 14 months work experience in Panchayati Raj Department Sector as District Project Manager & 12 months work experience in IT Sector as Software Engineer. :-)

Leave Comment

Comments

Liked By