LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
MelanieWW
 
Posts: n/a
Default

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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 07:25 PM
Problem with graph ranges No Such Luck Charts and Charting in Excel 6 December 3rd 04 01:09 PM
I enter numbers and they are stored as text burkeville Excel Discussion (Misc queries) 5 December 3rd 04 01:59 AM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 2 November 27th 04 01:55 AM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 0 November 26th 04 03:19 PM


All times are GMT +1. The time now is 03:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"