# If function to returrn blank

#### howard

##### Well-known Member
I have data in Col A. I have set up a formula to extract all the data to the left before - appears in Col A and to return a blank if the cell in A2 is blank. It extracts the required text perfectly

Code:
``=IF(A2="","",LEFT(A2,FIND("-",A2)-1)))``

I then wanted to add to the formula to return a blank where text "Total" appears in Col A for e.g. "Total outstanding - Current", but cannot get this to work

Code:
`` =IF(A2="*total*","",IF(A2="","",LEFT(A2,FIND("-",A2)-1)))``

It would be appreciated if someone can kindly assist me

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

#### AlanY

##### Well-known Member
try

=IF(OR(ISNUMBER(SEARCH("total",A2)),A2=""),"",LEFT(A2,FIND("-",A2)-1))

#### BarryL

##### Well-known Member
try:

=IF(OR(ISNUMBER(SEARCH("*TOTAL*",UPPER(A2))),A2=""),"",LEFT(A2,FIND("-",A2)-1))

#### howard

##### Well-known Member
Thanks for the help, much appreciated

Replies
5
Views
195
Replies
3
Views
251
Replies
9
Views
353
Replies
6
Views
399
Replies
1
Views
454

1,191,614
Messages
5,987,690
Members
440,104
Latest member
thigarette

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back