How to replace a text in a excel function.

Robert Kang
Robert Kang used Ask the Experts™
on
I want to change a text in a function.
I have $A$2 Want to change to $A2.

Thank you,
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
Select the cells where you want to replace the formulas and press Ctrl+H to open Replace window and follow the steps as shown in the following image.

Find-and-Replace.jpg

Author

Commented:
Thank you!
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome Robert!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial