Parsing out text or numbers
 

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.

Parsing out text or numbers
 

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

"Clay" wrote:

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.

Parsing out text or numbers
 

Try this, suppose the first example is in cell A1

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

"Clay" wrote:

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.