Doing a replace with a wildcard charcter

[John]

I have a set of data in the form
(9)
(12)
(8)
(34)
(45)
I would like to search and append a '0' to single characters between brackets.

Searching on (?) finds the correct items but (0?) does not turn (9) into
(09). Can any one help?

 

[Max]

One idea using a formula
Source data as posted is presumed TEXT running in A1 down
In B1: =IF(A1="","",IF(LEN(A1)=3,SUBSTITUTE(A1,"(","(0"),A1))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Jacob Skaria]

Another way

="(" & TEXT(MID(A1,2,LEN(A1)-2),"00") & ")"

If this post helps click Yes