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

[SoniaIta86]

Dear Members,

I have a problem in importing an excel file into Power Query : I have a column containing text with multiple space  that need to be preserved during the import process, but currently, the spaces are automatically removed upon import.

The table looks like this example

MaterialCode Material description

1234                Text PROD X          120KG PDR

3456                Text PROD X          1000KG IBC

25845              Text PROD X          BULK

25455              Text PROD YCS          BULK

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 

When I import the file in Power query all the multiple space are deleted.

1234      Text PROD X 120KG PDR

3456      Text PROD X 1000KG IBC

25845    Text PROD X BULK

25455    Text PROD YCS BULK

Is there any solution to avoid it?

thanks

Sonia

[SoniaIta86]

Hello ,

it is text in the original excel file. I realized one thing after your comment... it is only in the preview of power query that the text looks without space...

that means that I shuold be able to extract the part of the text I'm interesting in ! I will try and if I need support I will ask you! thanks!

[Cookistador · Accepted solution]

Hello @SoniaIta86 
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