Removing a sapce/letter from a column (only first letter)

[Anonymous]

 

Good day!

I have a problem with removing a space(letter) when transforming my data. I had to split a column via a comma that was between answers from a multiple answer question. Depending on the order and selection participants made the order of the answer was different but all came together in 1 column. However, upon splitting the natural wya is that the first option is in the first column, then the first split sending the 2nd answer to another column - no problem there.

However, all the splitted answers have a space in front of them compared ti the first column (the first answer made by participants) has none. Therefore, PowerBi reads it as seperate answers. 
Do you know how a small space can be removed from a column in a easy and quick way?
(Replace value would be perfect if I could select "Only first letter"). 

Thank you!

[Fowmy]

@Anonymous 

Can you provide sample data and the expected results in text format to come out with a suitable solution?

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[manikumar34 · Accepted solution]

@Anonymous , 

To remove whitespaces before and after the text use trim function from format in query editor.

Or add a step in advanced editor like this. 

= Table.TransformColumns(Source,{{"Column", Text.Trim, type text}})

Regards, 

Manikumar

If this is helpful, Accept as a Solution and leave a like.