ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   IF statement (https://www.excelbanter.com/excel-programming/394507-if-statement.html)

[email protected]

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



All times are GMT +1. The time now is 02:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com