ExcelHelp
23

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)

Ashutosh Thakre
273

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
dineshkumarji.dks
37

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.