View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Clay Clay is offline
external usenet poster
 
Posts: 29
Default 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.