Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381

Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381
Removing Unwanted Characters And Spaces From Text - Excel Tips - CiteHR

No Tags Found!

SH

Shai89308

Executive Hr

AS

Ammu Shanvi

Human Resource

GS

G SHASHI KRISHNA

Senior Manager - Hr

AH

Aizant HR

Human Resources

MA

MARSHAL

Safety Officer

AK

Anish Katoch

Hr Executive

PR

PranjalR

Hr Recruiter

AP

Alka Pal

Hr Executive

Karthikeyan8195

Management Consultant

MK

Mohit Kumar Puri

Head Marketing

AU

Austex

Accounts Manager


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, 840 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
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.




About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.