Need to add a space after every semi colon - Power Query

[Anonymous]

I have a column with below given type of text

India;USA;UAE;UK;Australia

I need to add a space after every semicolon. This need to be done in Power Query editor using M query.

Please help.

Expected Result - India; USA; UAE; UK; Australia

[amitchandak · Accepted solution]

@Anonymous , In power query, Right click on column or the small down arror -> replace value

;

; // give semicolon space

and try

Power Query Replace Value: https://youtu.be/hkZhZbR7Kmk