Thread: IF statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] lovepeaceofmind@yahoo.com is offline
external usenet poster
 
Posts: 29
Default IF statement

Hi, everyone:

One of my word bookmarks is called "BookMark1". ALL LINES (NO
EXCEPTIONS) within this BookMark1 have same structures outlined as:

A Indent1 B Indent2 C
where A, B, and C could be anything

Here is what I am looking for:
Case 1: If A is text and B is nothing and C is nothing, I would like
to delete Indent1, delete Indent2, and make the whole line text as
Bold

Case2: If A is a numerical number and B is text and C is nothing, I
would like to delete Indent2 and make the whole line text as Bold

Case 3: If there is more than 1 line where A is nothing and B is
nothing and C is nothing, I would like to keep only 1 line while
delete the other lines without doing anything else.

Any help will be highly appreciated!

Thanks,

Jorge