Parsing out text or numbers

[Clay]

I have cells that I would like the string after * parsed out into another
cell. My example of data looks like this.
LOT 1 - 2ND WAVE P/N 120168715 * Precihole
LOT 1.5 - 2ND WAVE P/N 101249134 * Dualong
DEDS-MECH-02 P/N 500-100-005084 * Hudo
DEDS-MECH-02 P/N 120158973 * Luaging

So I would envision Precihole being in its own cell after the formula has
run. And so on.

 

[Duke Carey]

select the column that has this data in it, then use the menu to choose

Data->Text to columns->delimited-> and check Other and put in the asterisk

Make sure there's an empty column to the right of this data

 

[AKphidelt]

Try this, suppose the first example is in cell A1

=RIGHT(A1,LEN(A1)-FIND("*",A1)-1)