Left of decimal with numerical and text values

**Bearack** · 09-20-2012, 10:10 AM

I have a conudrum and I can't seem to work through and I suspect I'll have a /DOH moment once one of you fine people answer.

I have a string I need to get only a piece of data from. The string is such (2500M65662.RHD) to which I only need the 65662 and I need it in numercial formation.

Thanks in advance.

Tim

**Bearack** · 09-20-2012, 10:13 AM

ANd to clarify, I have to do this through several strings where I only need the 5 characters to the left of the decimal.

**NBVC** · 09-20-2012, 10:14 AM

Is it always consistently 5 digits before decimal?

e.g.

=--MID(A1,FIND(".",A1)-5,5)

**Bearack** · 09-20-2012, 10:15 AM

Yes, or at least it should be. THanks, I'll give it a go and report back.

**ChemistB** · 09-20-2012, 10:16 AM

Is the numerical string always 5 digits? Does it always preceed the period? If not, what patterns are there?

If so,
=MID(A1,SEARCH(".",A1)-5,5)+0
Does that work for you?

Edit: Wow, I'm late for the party! LOL