• 0

Quick Excel Help


Question

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

  • 0

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

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.