B
Bill
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
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