- jigz - Posted March 21, 2012 Share Posted March 21, 2012 For some reason, I forgot how to do this in Excel. Let say coloumn 1 has the following: 1000 1001 1002 1003 .... I want do a find and replace, and append _v000 to it, so it would look like this: 1000_v000 1001_v000 1002_v000 1003_v000 .... Can someone help me with this? Link to comment Share on other sites More sharing options...
0 laycat Posted March 21, 2012 Share Posted March 21, 2012 You could create a new column, use a formula to append a string then using Copy -> Paste Values, and delete the old column... Say the data is in A:A, insert a new column and use: =A1&"_v000" Link to comment Share on other sites More sharing options...
0 - jigz - Posted March 21, 2012 Author Share Posted March 21, 2012 thank you so much laycat!!!! Link to comment Share on other sites More sharing options...
Question
- jigz -
For some reason, I forgot how to do this in Excel.
Let say coloumn 1 has the following:
1000
1001
1002
1003
....
I want do a find and replace, and append _v000 to it, so it would look like this:
1000_v000
1001_v000
1002_v000
1003_v000
....
Can someone help me with this?
Link to comment
Share on other sites
2 answers to this question
Recommended Posts