Forum Discussion
Solved
Extract initials from names column
OK, I have the following text column as part of a 19-column, several-thousand-rows table in PQ: I need to extract the initials of each name from the above column, so this added column would be...
Please try this expression in your custom column instead. It will work for any # of names. Replace [Names] with your actual column name.
= Text.Combine(List.Transform(Text.Split([Names], " "), each Text.Start(_,1)), "")
Pat
Please try this expression in your custom column instead. It will work for any # of names. Replace [Names] with your actual column name.
= Text.Combine(List.Transform(Text.Split([Names], " "), each Text.Start(_,1)), "")
Pat
