articles

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

Remove characters from text in Excel

AVADHESH PATEL5039 27-Mar-2013

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


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