Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 03-31-2015, 12:57 PM
Snakehips Snakehips is offline Removal first 7 typos Windows 8 Removal first 7 typos 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
 

Tags
12345



Similar Threads
Thread Thread Starter Forum Replies Last Post
Removal first 7 typos table removal syntax EAGLE SEU Word VBA 5 01-23-2015 10:57 AM
Removal first 7 typos Strange Characters Removal OceansBlue Word 2 04-03-2013 10:01 AM
Removal first 7 typos Please help with header and footer removal pwangdel Word 3 11-03-2011 06:10 AM
Removal first 7 typos Field removal from template Phelony Word 1 10-18-2011 03:28 AM
background graphic removal taffyevo PowerPoint 0 08-16-2011 06:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft