Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
I want to remove the spaces in middle of the field values.
I am attaching the sample excel file and Application
Thanks
Madhu
Please see the attached app
HI Sasidhar
Thanks a lot
PFA....
if we use this Exp : Replace(Description,' ','') as NewDescription
The sentence is Not proper to read .
Use SasiParupudi1
Expression
This solution is genius! Thank you so much @MK_QSL !
Unlike using the replace function. This MapSubString function would replace however the space duplicated in the string with just one space. Which it'd be a massive nested If statement if I use replace to achieve the same thing.
This is so overkill taking it all the way to 125, but even after 5 years of this post, I gotta give it to you, it is an elegant solution, and I like elegant.
Cheers
Brilliant solution, thnx!