Doing a replace with a wildcard charcter
 

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?

Doing a replace with a wildcard charcter
 

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
---
"John" wrote:
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?

Doing a replace with a wildcard charcter
 

Another way

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

If this post helps click Yes
---------------
Jacob Skaria


"John" wrote:

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?