Somewhere in these discussions I made a similar suggestion which was well
received by the original poster. I do not seem to be able to trace that
thread.
If you consider Excel and Visual Basic to be separate entities, then the
question in this thread would be an example. If not, then I would not say
this method can do what Excel cannot do. It is a tool just as Visual Basic
is a tool. The only comment that I can make is that in Search and Replace one
can get by without Visual Basic, which does require specialised knowledge.
Having said all this, I must admit that your macro suggestion is a neat and
efficient solution.

"Don Guillett" wrote:

No, I wouldn't claim to be that witty. I do think it funny to go thru the
procedure you describe to do a search. Perhaps you can give an serious
example of what Excel can't find that this convoluted procedure can.??

--
Don Guillett
SalesAid Software

"Martin P" wrote in message
...
I am not sure if you are being facetious. I believe Search and Replace to
be
the one area where Word is much more powerful than Excel.

"Don Guillett" wrote:

Word? Is that some kind of program? Who needs it?

--
Don Guillett
SalesAid Software

"Martin P" wrote in message
...
I would do this via Word. Copy the column to Word. Use Edit, Replace in
Word
to remove numbers that are not bold. Copy the remaining numbers to a
different column in Excel and add.

"Rich D" wrote:

I have a column of numbers and some of them are in boldface. How can
I
add
only the boldfaced numbers in the column?

Rich
--
Rich D
Armstrong Custom Homes
Redmond