count the same number of characters between two or three cells and update the remaining

Originally Posted by perus josh

Hi
count the same number of characters between two or three cells and update the remaining characters to the blank cell

please find the example the excel

input:-

WINCO FOODS
WINCO FOODS LLC
DUNEDIN CONSULTANTS
DUNEDIN CONSULTANT


the result should be

WINCO FOODS LLC
WINCO FOODS LLC
DUNEDIN CONSULTANTS
DUNEDIN CONSULTANTS

thank you

their is no solution for this ????

any expert can complete the issue

If a formula based solution is acceptable you might try the following:
1) Select cell B3 and paste the following array entered formula* into the formula bar:

Formula:

Please Login or Register  to view this content.

2) *Simultaneously press the Ctrl, Shift and Enter keys,
3) Drag the fill handle down to cell B12,
4) Paste the following regular formula into cell C3:

Formula:

Please Login or Register  to view this content.

5) Drag the fill handle down to cell C12.
Let us know if you have any questions.