I have a need to combine two columns, which I can do using the features from
PUP 6. What I would like to know how to do before I combine the columns, if
any of the cells in one column, (bracket) that information before combining

--

Regards
Michael Koerner

Think you left something out of your statement

If any of the cells in one column ? ? ?,

Also, What do you mean by bracket?

Do you want to indicate missing values by putting brackets in the string

"AAA" & "()"

If you physically want to put in the brackets

Dim rng as Range, rng1 as Range
set rng = Intersect(Range("A:B"),Activesheet.UsedRange)
On Error Resume Next
set rng1 = rng.Specialcells(xlBlanks)
On error goto 0
if not rng1 is nothing then
rng1.Value = "()"
End if

--
Regards,
Tom Ogilvy



"Michael Koerner" wrote in message
...
I have a need to combine two columns, which I can do using the features
from PUP 6. What I would like to know how to do before I combine the
columns, if any of the cells in one column, (bracket) that information
before combining

--

Regards
Michael Koerner