Removing all character 2 places to the right of decimal

[jermsalerms]

I am trying to write a formula that removes all characters that are more than two digits to the right of a decimal.

For example:

ex1- testmarket.24hpt converts to testmarket.24
ex2- 5893.4583830 converts to 5893.45
ex3- user.bjackson converts to user.bj

please let me know if you can help

[VBA Noob]

Hi,

With a helper column.

Enter this in B1 and drag down

=LEFT(A1,FIND(".",A1)+2)

Then paste special values

VBA Noob

[Carim]

Hi,

Please Login or Register  to view this content.