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

       

                ColumnA

       

      1             grapes

                     watermelon

                     cheese

      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

      Samuel