Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Make easier to use formula's / have better / useful examples | Excel Discussion (Misc queries) | |||
Procedure to make a dropdown list larger so it's easier to read | Excel Discussion (Misc queries) | |||
How do I set up excel to make estimating(pricing) easier? | Excel Discussion (Misc queries) | |||
Need a formula that would make life easier | New Users to Excel | |||
Need a formula that would make life easier | Excel Worksheet Functions |