Thread: [Solved] Removal first 7 typos
View Single Post
 
Old 03-31-2015, 12:57 PM
Snakehips Snakehips is offline Windows 8 Office 2013
Advanced Beginner
 
Join Date: Mar 2015
Posts: 36
Snakehips is on a distinguished road
Default

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.
Reply With Quote