![]() |
|
#3
|
|||
|
|||
|
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. |
| Tags |
| 12345 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
table removal syntax
|
EAGLE SEU | Word VBA | 5 | 01-23-2015 10:57 AM |
Strange Characters Removal
|
OceansBlue | Word | 2 | 04-03-2013 10:01 AM |
Please help with header and footer removal
|
pwangdel | Word | 3 | 11-03-2011 06:10 AM |
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 |