View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Martin P Martin P is offline
external usenet poster
 
Posts: 22
Default Formula to Add only the BOLDED numbers in a column.

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