wildcard for numbers

[dunlopoil]

Hi, I need to delete anything in a column after two decimal places. For example:

09.14ADC01A

should be displayed as 09.14

I know I can replace 09.14* with 09.14, but this number changes. Is there a way to specify a wildcard character to identify numbers only, and delete anything after these?

Thanks.

 

[Richard Schollar]

Hi

Formula or VBA based?

 

[dunlopoil]

Ideally formula based. Would it be easier to use the left or right formulas rather than replace?

 

[barry houdini]

For your example

=LEFT(A1,5)

But, obviously that only works if your number always has 5 characters (including decimal point).

 

[Richard Schollar]

Something like:

=MID(A1,1,FIND(".",A1&".")+2)

 

[dunlopoil]

Hi, using LEFT(A1,5) works great. Thanks.