Skip to main content
Contact a Moderator

Question

1
Replies
35
Views
 Yuvasaivarun mandadapu (yuvasaivarunm)
Ford Motor Company
RPA and DPA developer
Ford Motor Company
IN
yuvasaivarunm Member since 2019 1 post
Ford Motor Company
Posted: March 26, 2019
Last activity: March 28, 2019
Posted: 26 Mar 2019 12:50 EDT
Last activity: 28 Mar 2019 0:04 EDT
Closed

how to find and replace a letter in excel in a sheet

after opening a sheet i want to replace a letter in function place of a cell with other letter how can i achieve it?

***Edited by Moderator Marissa to update platform capability tags****

Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 2 years ago
Posted: 28 Mar 2019 0:04 EDT
Abirami Muthusamy (mutha1)
PEGA
Technical Solutions Engineer
Pegasystems Inc.
IN

Hi,


You can achieve this in the excel by using the "Find What" option where you can enter the character that you need to find and enter the character to be replaced in the "Replace With" field.


You can also use REPLACE function in the excel to replace the letters or any characters.


Thanks,

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice