LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make easier to use formula's / have better / useful examples nastech Excel Discussion (Misc queries) 1 October 30th 07 01:19 AM
Procedure to make a dropdown list larger so it's easier to read Jack Oziel Excel Discussion (Misc queries) 4 December 26th 05 05:49 PM
How do I set up excel to make estimating(pricing) easier? Ann from CCC Excel Discussion (Misc queries) 6 August 9th 05 08:22 PM
Need a formula that would make life easier frustrated New Users to Excel 2 May 29th 05 04:15 PM
Need a formula that would make life easier Frustrated Excel Worksheet Functions 1 May 29th 05 02:59 PM


All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"