LEN formula needed

Hi,
Not sure this is possible but I need a formula or macro, not Conditional Formatting, to do the following:

Column D, rows 1 to 3, contains one of the following choices (or a variation)

PP317181027CA
NR
2KAK030731045327775245600000

In Column C, rows 1-3, I would need to see the following result:

Row 1 - PP317181027CA
Row 2 - NR
Row 3 - 7310453277752456

Sorry, I am terrible with formulas and all I can manage is -
=LEN(d1)>25 but of course all it gives me is a true or false

But what I need is, if the length is greater than 25 I need the first 7 and last 5 numbers removed and the remaining value in the cell in column C -
from 2KAK030731045327775245600000 to 7310453277752456

If its less than 25 characters (as in Row 1 and 2 above) I need those complete values in C1 and C2

Any help would be greatly appreciated and apologies in advance if my explanation/problem is confusing.

Put this formula in C1:

=IF(LEN(D1)>25,MID(D1,8,16),D1)

then copy down.

Hope this helps.

Pete

You, my kind Sir, are freaking awesome. Works perfectly! Exactly what I need. Thank you so much for replying, especially so quickly. Would you mind explaining the 8 + 16 to me, if you don't mind.

Brenda

Originally Posted by BDD2015

I need the first 7 and last 5 numbers removed

Try this ...

=IF(LEN(D1)>25,MID(D1,8,LEN(D1)-12),D1)

Hi,
Thanks
I just picked 25 because those numbers definitely exceed 25
but I just needed it to be 7310453277752456 which means getting rid of the first 7 and last 5
Appreciate your interest but Pete_UK offered me a perfect formula.
But thanks so much.
Brenda

Thank you!
Pete_UK already gave me a formula that works but this works great too.
I will be looking at both so I can understand the logic.
Thank you for your help.
Regards, Brenda

Thank you. That makes it much clearer. Appreciate your time.

Brenda