Adding spaces between all characters in a string

[C-Duff84]

Hi, 

Wondered if anybody could help. I need to add spaces between all characters in strings in a column called [Names]

i.e the string 'Simon Jones', would become 'S i m o n  J o n e s'

Not sure whether I am missing a simple solution. Any assistance would be much appreciated. 

Thanks, 

[ImkeF · Accepted solution]

Hi @C-Duff84 ,
you could add a column like so: 
Text.Combine(List.Transform(Text.ToList([Names]), (l)=> l & " "), "")

Please also check the file enclosed.

[CNENFRNL · Accepted solution]

= Table.AddColumn(Source, "Spaced", each Text.Combine(Text.ToList([Name]), " "))

[C-Duff84]

Thanks! Appreciate your support

[ImkeF · Accepted solution]

Hi @C-Duff84 ,
you could add a column like so: 
Text.Combine(List.Transform(Text.ToList([Names]), (l)=> l & " "), "")

Please also check the file enclosed.

[C-Duff84]

Thanks ImkeF! Appreciate your response