Excel - Inverse of Concatenate

In your column C you have your sentences
In your column D you insert this formula
=MID(C1,FIND(",",C1,1)+1,LEN(C1)-(FIND(",",C1,1)))
to get the 2nd part of the sentence
that's what I understood

But you no longer want column C?
--
Currently looking for a job

Hello, here is a possible formula
=MID(B5,FIND(",",B5,1),LEN(B5)-FIND(",",B5,1))

My formula only works if there is only one comma in your sentence
--
Currently seeking a job

you can also try this:

=RIGHT(A1;LEN(A1) - SEARCH(",";A1))

and if you want to remove the right part, you'll need to create a vbs macro.

Unless you want to create a column with only the left part...

Otherwise
in column D
=LEFT(C1,LEN(C1) - FIND(",",C1))
in column E
=RIGHT(C1,LEN(C1) - FIND(",",C1))
this gives you your 2 parts of the sentence

easier to write the solution from zavenger ;)

//
Here is the macro solution from eriic
Sub Macro1()
Columns("C:C").Select
Selection.TextToColumns Destination:=Range("C1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo _
:=Array(Array(1, 1), Array(2, 1)), TrailingMinusNumbers:=True
End Sub

--
Currently looking for a job