Home > DeveloperSection > Articles > Remove characters from text in Excel

Remove characters from text in Excel


Excel Excel 
Ratings:
0 Comment(s)
 2226  View(s)
Rate this:

Remove characters from text in Excel

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

Remove characters from text in Excel


Don't want to miss updates? Please click the below button!

Follow MindStick