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?