=IF(A1="","",formula)

If this post helps click Yes
---------------
Jacob Skaria


"Jim" wrote:

Jacob,

How would I write these formulas to show a blank field instead of an error
if the cell it is referring to is blank?

Thanks again for the help.

Jim

"Jacob Skaria" wrote:

You can try menu DataText to ColumnsDelimiter and select hyphen to split
this to two columns. If you are looking for formulas try the below

In B1
=TRIM(LEFT(A1,FIND("-",A1)-1))

In C1
=TRIM(MID(A1,FIND("-",A1)+1,LEN(A1)))

--
If this post helps click Yes
---------------
Jacob Skaria


"Jim" wrote:

Hello,

In cell A1 I have the following:

L2D376 - COE

I would like to break up this data into two cells.

In Cell B1 I would like L2D376 to show

In Cell C1 I would like COE to show

I do not need the - at all.

Thanks for the help.
Jim