Thread: How to Replace 1 letter in each Cell

Hello,

I'm working on a lead report and I'm stumped. I'm new to the forums and was wondering if any of you could help me out.

I'm working on two tabs, the second of which uses column information from the first so each cell in Tab 2 contains =Tab1!F53

What I want to do is change that F to another letter in all instances in the column, is this possible?

Thank you in advance!

Originally Posted by Andy Pope

you could use Find/Replace

Find: =Tab1!F
Replace: =Tab1!G

Select the range of cells to be altered and then user CTRL+H to bring up Find/Replace dialog.

Awesome! Thanks for your help.

I realize this is small potatoes to most of the problems on this forum but thank you for taking the time!