Help breaking up data in a cell

[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

 

[NBVC]

Copy column A to Column B and then Select Column B and go to Data|Tex
to columns and select Delimited, click Next.

Then select Space and Other and enter a dash "-" in the empty box nex
to Other..

Click Finish.

If you don't want Column A at all, then skip the copying to column
and perform the above actions in column A

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com

 

[Jacob Skaria]

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)))

 

[Stefi]

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:

 

[Jim]

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

 

[Jim]

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]

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

If this post helps click Yes