Assume that my my data is 44107-8876342018-2


I have 2203 entries in XL of similar type.Now I want to remove 44107 from all 2203 cells. How it is possible by using formula?

Hi,

Not sure about a formula. But you can have a code to do it.
You mention the first 7 characters. Do you really want to remove from the first "-" to the beginning of the text?

Ie "44107-"

To let you know I'll be gone in about 5 minutes. If you do not receive an answer while I'm gone I'll take a look when I get back.

Chetan Seebra,

It's not 100% clear to me what you are wanting to remove.
44107 is only 5 characters 6 if you include the '-'

Anyway here are two options that may help.

Assumes string in eg A1
=RIGHT(A1,LEN(A1)-6)
Gets rid of the leading 6 characters whatever they are. Edit 6 to suit.

or
=SUBSTITUTE(A2,"44107-","")

Substitutes the specific red string with nothing ""

You said 'remove 7 typos' If they are typos that need replacing with a corrected string then use that replacement string instead of ""

Hope that helps.