Separating data in the same cell

I'm needing to separate some data in columns. Here is a sample:
Thomas, Nehemiah JR 1,837.05 ; Tiller, Tanika 2,163.72 ; Tobin, Terri
1,182.66 ;

That is all in one cell. The individual entries are separated by semicolons.
I need to get the names in separate cells below each other in the same
column, and the numbers next to them in the same row and not in the same cell
with the names. Like this:

Column A - Thomas, Nehemiah JR Column B - 1,837.05
Column A - Tiller, Tanika Column B - 2,163.72
Column A - Tobin, Terri Column B - 1,182.66

Is there a formula I could use, or a way to do that automatically? Any way
at all to at least avoid separating the names manually and then separating
the numbers manually and deleting them in the other cell?

That might be incredibly difficult, so here is a hopefully easier problem
related to my first. This is an example of another cell which I need to
separate data:
TRIUMPH LEARNING 2539

This data is in the same cell, I need to get it in two separate cells, and
the number deleted from the first cell, like above. I know that I can use the
RIGHT function to get the number in the cell next to it, but is there a way
to then make it so that the number is deleted from the cell with the words?

Pls post in ONE group

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jor" wrote in message
...
I'm needing to separate some data in columns. Here is a sample:
Thomas, Nehemiah JR 1,837.05 ; Tiller, Tanika 2,163.72 ; Tobin, Terri
1,182.66 ;

That is all in one cell. The individual entries are separated by
semicolons.
I need to get the names in separate cells below each other in the same
column, and the numbers next to them in the same row and not in the same
cell
with the names. Like this:

Column A - Thomas, Nehemiah JR Column B - 1,837.05
Column A - Tiller, Tanika Column B - 2,163.72
Column A - Tobin, Terri Column B - 1,182.66

Is there a formula I could use, or a way to do that automatically? Any way
at all to at least avoid separating the names manually and then separating
the numbers manually and deleting them in the other cell?

That might be incredibly difficult, so here is a hopefully easier problem
related to my first. This is an example of another cell which I need to
separate data:
TRIUMPH LEARNING 2539

This data is in the same cell, I need to get it in two separate cells, and
the number deleted from the first cell, like above. I know that I can use
the
RIGHT function to get the number in the cell next to it, but is there a
way
to then make it so that the number is deleted from the cell with the
words?