View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Formula to Add only the BOLDED numbers in a column.

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