Help breaking up data in a cell
 

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

Help breaking up data in a cell
 

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

Help breaking up data in a cell
 

DataText to columnschoose "-" as separator after checking Other box, use
Trim function to get rid of redundant spaces!
Regards,
Stefi


€žJim€� ezt Ã*rta:

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

Help breaking up data in a cell
 

I like having the two option. Thanks for the formula's, I appreciate
learning more about how formula's are written.



"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

Help breaking up data in a cell
 

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

Help breaking up data in a cell
 

=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