Help breaking up data in a cell

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

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
 
You can try menu Data>Text to Columns>Delimiter 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)))
 
Data>Text to columns>choose "-" as separator after checking Other box, use
Trim function to get rid of redundant spaces!
Regards,
Stefi


„Jim†ezt írta:
 
I like having the two option. Thanks for the formula's, I appreciate
learning more about how formula's are written.
 
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
 
Back
Top