Hi Folks,
In this posting we are going to find out how to use an excel formula to remove the unwanted characters and spaces from a text.
Formula is available in the attached file. Go through it and let me know your thoughts..

From India, Chennai
Attached Files (Download Requires Membership)
File Type: xls Removing Unwanted Characters From Text.xls (35.5 KB, 846 views)

Hi,
Really helpful.... as most of the times the characters or spaces come when converting the same from a different software.... Especially for a person like me handling huge data, this is like a magic wand....
Thanks for sharing...
Regards,
Ashutosh Thakre

From India, Mumbai
Really a great job. It is also very useful for me. I was totally unknown to all these tricks. Nice work. Keep Posting........... Thanks & Regards Dinesh Kumar
From India, New Delhi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.