3 Replies Latest reply: Nov 13, 2015 6:49 PM by Doug Nichols RSS

    Excel column- some items turning into nulls to to alpha prefix

    Doug Nichols

      I have an excel column that looks like the below:

       

      All I want to capture is the 1033213.  When I pull the in data prep or classic monarch, all of the numbers that begin with PRG at the bottom turn into nulls?  Is there a way to capture that data.  Even if I could capture the whole description of -   PRG1072967 I could clean it up in data prep.  Thanks for your help in advance.