Need excel formula help_RIGHT(F6,FIND(".",F6,1)) does not work.

[pedie]

i need to get the text coming after "." like xlsm from book1.xlsm
I used this and also tried others few but not givving accurate answer....please check it for me...
Thanks

'=RIGHT(F6,FIND(".",F6,1))
'=RIGHT(RIGHT(F6,FIND(".",F6,5)),4)

 

[barry houdini]

Try this

=REPLACE(F6,1,FIND(".",F6),"")

 

[pedie]

Perfect, thanks for helping

 

[tusharm]

Check out the MID function. You should land up with something along the lines of MID(...,FIND(...),...) where you have to provide the appropriate cell references or values in the ... parts.

 

[pedie]

Check out the MID function. You should land up with something along the lines of MID(...,FIND(...),...) where you have to provide the appropriate cell references or values in the ... parts.

the earlier formula works perfect but thought i'd just give a try....'=MID(C5,FIND(".",C5,1)..and this formula does not work...

 

[jasonb75]

the earlier formula works perfect but thought i'd just give a try....'=MID(C5,FIND(".",C5,1)..and this formula does not work...

To do it with mid

=mid(c5,find(".",c5)+1,len(c5))

Think I prefer Barry's suggestion though, looks much cleaner than any other method.

 

[Nalani]

And another way with MID (1 less calculation)

=MID(C5,FIND(".",C5,1)+1*1,5)

But I agree with jason:

Barry's is even shorter with only 4 calculations

 

[pedie]

Thanks again guys! All of them works!
Thanks for sharing ideas....