Formula return empty if the cell is empty

**iwanttoexcelinexcel** · 09-15-2022, 02:19 AM

Hi,

I have a formula and I want to return the cell empty if the formula that i am applying is empty as well, not #value!.

Please see attached.

Thanks,

**shukla.ankur281190** · 09-15-2022, 02:23 AM

Try

B74=IF(A74="","",LEFT(A74,LEN(A74)-11))

**AliGW** · 09-15-2022, 02:26 AM

Or:

=IFERROR(LEFT(A74,LEN(A74)-11),"")

**iwanttoexcelinexcel** · 09-15-2022, 02:27 AM

Thank you mate

**AliGW** · 09-15-2022, 02:38 AM

You had TWO solutions ...

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

Formula return empty if the cell is empty

LinkBack

Thread Tools

Rate This Thread

Display

Formula return empty if the cell is empty

Re: Formula return empty if the cell is empty

Re: Formula return empty if the cell is empty

Re: Formula return empty if the cell is empty

Re: Formula return empty if the cell is empty

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Return formula when cell not empty

IFERROR with Index Match need to return numeric empty cell not text empty cell

[SOLVED] TIME between two dates - want to return blank if empty and use today if end date is empty

[SOLVED] Formula to return empty string instead of null when column table is empty

[SOLVED] Subtracting a 0 from a empty cell and wanting to return a empty cell

How to get array formula to return an empty cell instead of 00-Jan-00

[SOLVED] return an EMPTY cell in an IF formula

Bookmarks

Bookmarks

Posting Permissions