split world in 2 column

Here is explanation of formulas:

1) =LEFT(A1, FIND(",", A1&",")-1)

LEFT function take LEFT part of the word. LEFT(text,num_chars)

How many num_chars? Answer: up to first , that appear

That's why you need FIND(",", A1&",")-1

FIND(",", A1)-1 would also work but it will return you error if no , in the word.
That's why FIND(",", A1&",")-1 is added. To ensure that , will apear.
(if there is more then one it will take first)


2) =IF(ISERR(FIND(",", A1)), "", ",")

Easier way to get , in this column would be to just write it.
,
just as that.

However, what if there is no , character in your word?
Just yell instead of yell,scream
Then you'll get an error.

So we will test:

IF
is it error when finding , in word in A1
- if yes then return blank cell ("")
- if no (no error, means there is a , in cell) return ,

3) now when we take yell and , from yell,scream we need to take last word.

=IF(C1=",", MID(A1, FIND(",", A1)+1, 100), "")

If there is , in C1 (and that would be for all words that has , like yell,scream)
Find where , start

Take 100 characters from that point forward

and that's the result.

If there is no , in C1 leave blank cell

slight variation, but depends on the comma always being there

Hi actroidf

At this stage I would strongly recommend you to go for a course for excel basics. You can then use the forums for further advancement.