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
Hi leolapa ,
You are absolutely right. My solution was not scalable. I apologise 🙂 Does mahoneypat's solution work for you?
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
No apologies needed...
mahoneypat's solution worked out just fine.
Thanks!