need formula to drop digits

[CRAIG20]

Hi

I have a column F which lists numbers - all numbers are 16 digits

I would like a formula that will list the digits 11-15 and drop the first 10 and the last one

Thanks in advance

craig

 

[PaddyD]

=mid(a1,11,4)

?

 

[CRAIG20]

great. thank you very much

 

[CRAIG20]

Also. Can you help me wit this one. I have a list of dates 12/01/2014. Can I have a formula that will drop the '/' so it will just leave it as 12012014

 

[PaddyD]

ADVERTISEMENT

if they are 'proper' dates, then just change the formatting.

if they're text values:

substitute(a1,"/","")

 

[CRAIG20]

thanks again!

 

[PaddyD]

no worries.