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

Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381
Excel Tips - Replacing Text Values Only From A Column Which Contains Both Numerical And Text Values - 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,
I had a question from a participant last week, when I have a data containing both text and numbers. Is it possible to perform any action on the text values or numerical values alone?
This requirement can be achieved in multiple ways. Out of them this could be little quick. I have listed down the process in the excel file itself. File is available in this posting under the "Attachments".
Awaiting your comments!

From India, Chennai
Attached Files (Download Requires Membership)
File Type: xls Replacing Text Values Alone.xls (26.5 KB, 210 views)

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 @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.