Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Yuvasaivarun mandadapu (yuvasaivarunm)
Radial
Yuvasaivarun mandadapu
Radial
IN
yuvasaivarunm Member since 2019 2 posts
Radial
Posted: Mar 26, 2019
Last activity: Mar 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****

To see attachments, please log in.
Reporting

Posted: 5 years ago
Posted: 28 Mar 2019 0:04 EDT
Abirami Muthusamy (AbiramiM17280411)
CommonWealth Bank of Australia

CommonWealth Bank of Australia
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,

To see attachments, please log in.

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