Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
Using an IF statement, or VLOOKUP statement | Excel Programming | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |