#1
|
|||
|
|||
Removal first 7 typos
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? |
#2
|
|||
|
|||
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. |
#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 |