![]() |
#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 |
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 |