Thread
:
Formula to Add only the BOLDED numbers in a column.
View Single Post
#
11
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett