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.