Adding spaces between all characters in a string

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 s...

Need Help

ImkeF
3 years ago
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.

Adding Spaces Between all Characters.pbix15 KB

CNENFRNL

3 years ago

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

ImkeF

Community Champion

3 years ago

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.

Adding Spaces Between all Characters.pbix15 KB

C-Duff84
Regular Visitor
3 years ago
Thanks ImkeF! Appreciate your response

Forum Discussion

Adding spaces between all characters in a string

Related content

Adding columns

Export data strange characters

Quote Character

Adding a column

Adding leading and trailing characters to measure