LEN formula needed

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