![]() |
|
#1
|
|||
|
|||
![]()
I dont know this work or not , I want to find a character and replace with same character by reducing its length. For example I want to find the 'aaaaaa' and replace with 'aa'. the formula for replacing is divided by three. Eg: 'hhhhhhhhh' then it should replace to 'hhh' . what ever in the find box , it should be replaced with same letter by dividing its length by 3. please help
|
#2
|
||||
|
||||
![]()
For what you described, you could use a wildcard Find/Replace, where:
Find = ([a-z])\1\1 Replace = \1
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
Thank you so much. This worked like charm.
![]() |
#4
|
||||
|
||||
![]()
Bravo Paul
That is a brilliantly simple solution that I would never have considered. ![]()
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
![]() |
Tags |
find and replace |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do you use the find and replace tool to find dates and times in Excel 2013? | Jules90 | Excel | 3 | 04-14-2020 07:40 PM |
![]() |
Hoxton118 | Word VBA | 7 | 06-10-2014 05:05 AM |
![]() |
bertietheblue | Word VBA | 12 | 11-04-2013 05:35 PM |
![]() |
paulkaye | Word | 4 | 12-06-2011 11:05 PM |
![]() |
paulkaye | Word | 1 | 11-13-2011 04:23 AM |