Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace using wildcard, or else | Excel Discussion (Misc queries) | |||
find & replace - digit wildcard | Excel Discussion (Misc queries) | |||
Find and Replace Command Using Wildcard Help | Excel Discussion (Misc queries) | |||
Find Replace Wildcard | New Users to Excel | |||
How do you find and replace a Wildcard character in Excel? | Excel Discussion (Misc queries) |