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.
|