View Single Post
  #2   Report Post  
MelanieWW
 
Posts: n/a
Default Is there a way I can enter a letter to proceed text a column of ce

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...