Ashutosh Thakre
Hr Professional
+1 Other

PRIME SPONSOR - FACTOHR - Customised Payroll, GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
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..

Attached Files
Membership is required for download. Create An Account First
File Type: xls Removing Unwanted Characters From Text.xls (35.5 KB, 808 views)

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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...
Ashutosh Thakre
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
PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
Add Reply Start A New Discussion

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™