In this article I have described how to split a text form text-column in excel. There are several ways to remove characters from text. For removing text from column in Excel, Excel provides two functions LEFT/LEFTB and RIGHT/RIGHTB.
LEFT returns the first character or characters in a text string, based on the number of characters you specify. LEFT always counts each character, whether single-byte or double-byte, as 1, no matter what the default language setting is.
LEFTB returns the first character or characters in a text string, based on the number of bytes you specify. LEFTB counts each double-byte character as 2 when you have enabled the editing of a language that supports DBCS and then set it as the default language. Otherwise, LEFTB counts each character as 1.
Syntax
LEFT(text,num_chars)
LEFTB(text,num_bytes)
RIGHT returns the last character or characters in a text string, based on the number of characters you specify. RIGHT always counts each character, whether single-byte or double-byte, as 1, no matter what the default language setting is.
RIGHTB returns the last character or characters in a text string, based on the number of bytes you specify. RIGHTB counts each double-byte character as 2 when you have enabled the editing of a language that supports DBCS and then set it as the default language. Otherwise, RIGHTB counts each character as 1.
Syntax
RIGHT(text,num_chars)
RIGHTB(text,num_bytes)
Example are given below
Leave Comment