Splitting a name using chr(10)

[288enzo]

I'm very new to R1C1, and I'm trying to split a name at the comma and use chr(10) between the first and last name.

This is my starting point

2.xls
	F
2	Martinez, Ernesto
Report

Next I created a few helper columns

Cells(2, 10).FormulaR1C1 = "=RIGHT(RC[-4],FIND("","",RC[-4])-2)"
Cells(2, 11).FormulaR1C1 = "=LEFT(RC[-5],FIND("","",RC[-5])-1)"

2.xls
	F	G	H	I	J	K
2	Martinez, Ernesto				Ernesto	Martinez
Report

Cell Formulas
Range	Formula
J2	J2	=RIGHT(F2,FIND(",",F2)-2)
K2	K2	=LEFT(F2,FIND(",",F2)-1)

My goal would be the final result in 2,9 aka I2

2.xls
	F	G	H	I	J	K
2	Martinez, Ernesto			Ernesto Marinez	Ernesto	Martinez
Report

Cell Formulas
Range	Formula
J2	J2	=RIGHT(F2,FIND(",",F2)-2)
K2	K2	=LEFT(F2,FIND(",",F2)-1)

I tried

Cells(2, 9).FormulaR1C1 = "=RIGHT(RC[-3],FIND("","",RC[-3])-2)" & Chr(10) & "=LEFT(RC[-3],FIND("","",RC[-3])-1)"
Cells(2, 9).FormulaR1C1 = "=RIGHT(RC[-3],FIND("","",RC[-3])-2)" & Chr(10) & "LEFT(RC[-3],FIND("","",RC[-3])-1)"
Cells(2, 9).FormulaR1C1 = "=RC[1]" & Chr(10) & "=RC[2]"
Cells(2, 9).FormulaR1C1 = "=RC[1]" & Chr(10) & "RC[2]"

 

[Fluff]

It needs to be

Cells(2, 9).FormulaR1C1 = "=RIGHT(RC[-3],FIND("","",RC[-3])-2) & Char(10) & LEFT(RC[-3],FIND("","",RC[-3])-1)"

 

[288enzo]

It needs to be

Cells(2, 9).FormulaR1C1 = "=RIGHT(RC[-3],FIND("","",RC[-3])-2) & Char(10) & LEFT(RC[-3],FIND("","",RC[-3])-1)"

That worked, I forgot about the relative position changing. I am curios as to why I use Char(10) and not Chr(10).

In the past, I always would use Chr(10) -

    Cells(2, 9).Value = "HELLO" & Chr(10) & "HELLO"

 

[Fluff]

Chr is a VBA function, whereas Char is the worksheet function.