topic Re: load excel values separated by commas in QlikView https://community.qlik.com/t5/QlikView/load-excel-values-separated-by-commas/m-p/460717#M171992 <HTML><HEAD></HEAD><BODY><P>Its hard to tell exactly what your issue is without an excel file to examine. It looks like you don't means spaces. Are Fire and Room in the same cell on different lines? Is so, they are separated by a line feed.</P></BODY></HTML> Wed, 17 Apr 2013 13:48:24 GMT m_woolf 2013-04-17T13:48:24Z load excel values separated by commas https://community.qlik.com/t5/QlikView/load-excel-values-separated-by-commas/m-p/460714#M171989 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I am trying to load an excel in which one column has values separated by Spaces as below </P><P></P><P>Col A</P><P></P><P>Fire</P><P>Room</P><P></P><P></P><P></P><P>Dog</P><P></P><P></P><P></P><P>Yellow</P><P>Red</P><P></P><P>when i reload this data in qlikview its read as below for the cell in which there are 2 values Fire and Room , its fetching only first value ....i tried purgechar,ltrim,rtrim,trim ..but nothing seems to work., </P><P></P><P>Col A</P><P></P><P>Fire</P><P>Dog</P><P>Yellow</P><P></P><P></P><P>How do i load data as it is in excel?</P><P></P><P>Thank you</P></BODY></HTML> Tue, 16 Apr 2013 19:42:49 GMT https://community.qlik.com/t5/QlikView/load-excel-values-separated-by-commas/m-p/460714#M171989 Anonymous 2013-04-16T19:42:49Z Re: load excel values separated by commas https://community.qlik.com/t5/QlikView/load-excel-values-separated-by-commas/m-p/460715#M171990 <HTML><HEAD></HEAD><BODY><P>Can someone help on this .. the suvject is wrong ...i meant loading excel values separated by spaces </P></BODY></HTML> Tue, 16 Apr 2013 20:30:12 GMT https://community.qlik.com/t5/QlikView/load-excel-values-separated-by-commas/m-p/460715#M171990 Anonymous 2013-04-16T20:30:12Z Re: load excel values separated by commas https://community.qlik.com/t5/QlikView/load-excel-values-separated-by-commas/m-p/460716#M171991 <HTML><HEAD></HEAD><BODY><P></P><P>Hi,</P><P></P><P>Can you attach the excel and qv file you are working?</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 17 Apr 2013 06:20:40 GMT https://community.qlik.com/t5/QlikView/load-excel-values-separated-by-commas/m-p/460716#M171991 jagan 2013-04-17T06:20:40Z Re: load excel values separated by commas https://community.qlik.com/t5/QlikView/load-excel-values-separated-by-commas/m-p/460717#M171992 <HTML><HEAD></HEAD><BODY><P>Its hard to tell exactly what your issue is without an excel file to examine. It looks like you don't means spaces. Are Fire and Room in the same cell on different lines? Is so, they are separated by a line feed.</P></BODY></HTML> Wed, 17 Apr 2013 13:48:24 GMT https://community.qlik.com/t5/QlikView/load-excel-values-separated-by-commas/m-p/460717#M171992 m_woolf 2013-04-17T13:48:24Z