4 Replies Latest reply: Dec 9, 2015 6:49 AM by Sangram Reddy RSS

    Load only certain content in each Excel cell

    Samuel Lin

      Hi there,


      (1) If I have a column (.xlsx) that has multiple lines such as




      1             grapes



      is it possible to load only the second line? "watermelon" for all the data in Column A?


      (2) Is it possible to load data within certain "symbols"? for example, only load a column's data within quotation, or within $$, or content after/before @



      Thank you so much for your help and reading through to understand this discussion