How to round a number off when contained in text

I have a table with data in it where significance testing has been completed. The relevant cells look like:
0.113(*)

I want to round the number portion of the cell, whilst still keeping the asterisk (denoting that the result was significant), so that the cell will look like this:
0.11*

I was wondering if there was a formula to do this? The tricky part I am finding is the rounding off (i.e., the removal of the parentheses I can do by finding/replacing them).

if it is literally parenthesis, you can do it utilizing the find function and round function, no matter the amount of numbers (if it is all with number first like that).

It would help if you give sample data first though, because you can possibly solve this with simple left/right instead of a bunch of nested find making it hard to follow what's going on in the formula.

The data looks like this:

Data .jpg

=IFERROR(ROUND(LEFT(A1,FIND("(",A1)-1)+0,2)&REPT("*",LEN(A1)-LEN(SUBSTITUTE(A1,"*",""))),ROUND(A1,2))

Going by your example, if you just want to truncate the number rather than rounding it, then you can do it with one operation using Find & Replace (CTRL-H).

Select all the cells, then CTRL-H, and:

Find what: ?(
Replace with: (
Click Replace All

the ?( characters stand for a single character in front of the open bracket, and replace that with a single bracket.

Hope this helps.

Pete

Thanks for the code: =IFERROR(ROUND(LEFT(A1,FIND("(",A1)-1)+0,2)&REPT("*",LEN(A1)-LEN(SUBSTITUTE(A1,"*",""))),ROUND(A1,2))

It solved the problem.