help with get just the name out

[rcirone]

I have this and I need to get the first and last name out so I can use them for a vlookup please help

Richard XXXXXX 1993446666
Tom XXXXXXX 1993444444

I am using this
=RIGHT(G7,SEARCH("",G7,10))
but I need to use the name now

 

[rcirone]

[TABLE="width: 359"]
<tbody>[TR]
[TD="width: 251, bgcolor: transparent"]This is the way it come in

[/TD]
[TD="width: 15, bgcolor: transparent"][/TD]
[TD="width: 213, bgcolor: transparent"]This is What I need it to look like
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Yxxxxxx Oxxxx Mxxxxxx 1993444444
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Ortiz Mxxxxxx, Yxxxxxx ICE
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Sxxxxxx Pxxxxxx 1993443333
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Pxxxxxx, Sxxxxxxx ICE
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Jxxxx Pxxxxx 1993442222
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Pxxxxx, Jxxxx ICE
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Sxxxxxx Pxxxx 1993442211
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Pxxxx, Sxxxxxx ICE
[/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Try this:

Book1
	A	B
1	Yxxxxxx Oxxxx Mxxxxxx 1993444444	Oxxxx Mxxxxxx, Yxxxxxx ICE
2	Sxxxxxx Pxxxxxx 1993443333	Pxxxxxx, Sxxxxxx ICE
3	Jxxxx Pxxxxx 1993442222	Pxxxxx, Jxxxx ICE
4	Sxxxxxx Pxxxx 1993442211	Pxxxx, Sxxxxxx ICE
Sheet201

Cell Formulas
Range	Formula
B1	=MID(LEFT(A1,LEN(A1)-11),FIND(" ",A1)+1,255)&", "&LEFT(A1,FIND(" ",A1))&"ICE"

Formula copied down.