If Cell is blank, ignore formula and cell = blank

Hi guys,

My first post on here. Thanks in advance for the help!


Here are the formulas that I am currently using to extract data from a cell and paste it into another cell.

=TEXT(IF(ISERROR(LEFT(R11,FIND($E$1, R11)-1)), R11,LEFT(R11, FIND($E$1, R11)-1)), "000")

=IF(ISERROR(RIGHT(R11,LEN(R11)-FIND("-",R11))), "",RIGHT(R11,LEN(R11)-FIND("-",R11)))

=IF(ISNUMBER(VALUE(RIGHT(S11,1)))=FALSE, TEXT(LEFT(S11, LEN(S11)-1), "00")&RIGHT(S11, 1), S11)

I would like to add a condition where IF R11 is blank, than the cell that this formula is in would also be blank.

Here is a sample of the data

TML ID Spool Location Spool2
001HT3EB-002 001 002 001
001HT3EB-003 001 003 001
002HT3EB-002 002 002 002
002HT3EB-003 002 003 002
003HT3EB-002 003 002 003


Again, thanks in advance for the help!