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

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

Choose: 1) Do you want "W" to be an actual part of the cell value? or 2) do
you just want it to look like it's there but have the data remain as is?

1) In an empty column next to the original data, enter the formula

="W"&A1

where A1 is the adjacent cell with the original data. Copy the formula down
the rest of the way to apply it to the rest of the original column. Cut
that new column and "Paste Special, Values" over the top of the original
column.

<or

2) Creat a custom Format.

Select the column
FormatCells
Category = Custom
Type = "W"@ (enter this on that line and it will be added to the list below)
Click "OK"

Hope that helps.

"MelanieWW" wrote in message
...
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...

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