Thanks Gordon! This solves the issue. Much appreciated!

"Gordon" wrote:

MelanieWW wrote:
I need to enter a source code (letter W) before all the text that I
have listed in a column. Example: All of column C has text...
MPV001, MPV002, MPV003, ETC. I need to put a "W" in front of all the
text. i.e. WMPV001, WMPV002, WMPV003, ETC. Is there a way to do this
without manually typing W in all the cells? The spreadsheet has 1500
rows...

If all the cells begin with, say, "M" then go to Find and Replace and
replace M with WM