View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bill Bill is offline
external usenet poster
 
Posts: 390
Default Help with a procedure to make things easier

With Excel 2007

I have data (both text and numbers) in column A. Some of the "text" is
underlined. I would like to place an x in column B next to the data in
column A that is underlined. See below. I would like to place the x in
column B in the easiest manner possible, automatically without placing the
"x" manually for each item since I have a few thousand rows. Also, I would
like to do this without using a macro.

Since I am unable to underline in this post, the following data in column A
is underlined. Also, you can see an "x" in column B corresponding to this
data:

Fruits
Meat
Milk
Fish
Lamb


Any suggestions.

Thank you,

Bill



Column A Column B

Fruits x
Vegetables
5
Meat x
6
Milk x
Bread
Beverage
Fish x
9
Lamb x
Soup