Power query Issue in importing text from excel file- space automatically delete in a text column

Question

Dear Members,I have a problem in importing an excel file into Power Query : I have a column containing text with multiple space &nbsp;that need to be preserved during the import process, but currently, the spaces are automatically removed upon import.The table looks like this exampleMaterialCode Material description1234&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Text PROD X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 120KG PDR3456&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Text PROD X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1000KG IBC25845&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Text PROD X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BULK25455&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Text PROD YCS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BULK&nbsp;the Material description does not have a fix lenght but beetween the first part of the description that identify the product name and the second part that identify the packing type there are always 11 empty space&nbsp;When I import the file in Power query all the multiple space are deleted.1234&nbsp; &nbsp; &nbsp; Text PROD X 120KG PDR3456&nbsp; &nbsp; &nbsp;&nbsp;Text PROD X 1000KG IBC25845&nbsp; &nbsp; Text PROD X BULK25455&nbsp; &nbsp; Text PROD YCS BULK&nbsp;Is there any solution to avoid it?thanksSonia&nbsp;

cookistador · Accepted Answer

Hello SoniaIta86&nbsp;What is the format of the data you are imported ?Because I've done some trials, and the results is always return with the 11 spaces

Forum Discussion

Power query Issue in importing text from excel file- space automatically delete in a text column

2 Replies

Related content

Automatically delete data from import

Automatics Refresh

Import monthly data automatically

Monthly Automatic Change

Can't delete Fabric items no Delete option available