Forum Discussion
Solved
Power query Issue in importing text from excel file- space automatically delete in a text column
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, ...
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
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!