Add to exsiting data in Multiple cells

jdogrulz

New Member
Joined
Jul 29, 2010
Messages
3
I have 1000 products and each have an SKU number column. I want to add "X-" to the beginning of each number. How can I do this?
Please help,
Jeff
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

PA HS Teacher

Well-known Member
Joined
Jul 17, 2004
Messages
2,838
in A helper column, lets say column Z (it doesn't really matter).
In Z2:
="X-" & A2

Past down as far as needed.

Highlight Column Z.
Copy
Highlight Column A

Edit, Paste Special Values
 

jdogrulz

New Member
Joined
Jul 29, 2010
Messages
3
HI,
Thanks for the quick reply. I understand about 90% of what ur saying. The only part im not sure on is when I put in the formula, do I have to do each cell by hand? ="X-" & A2, ="X-" & A3, ="X-" & A4...etc?? Or can I just highlight my helper column and use some kind of formula that covers cells A2 to A6005 (thats how many cells there are!).

thanks again,
Jeff
 

PA HS Teacher

Well-known Member
Joined
Jul 17, 2004
Messages
2,838
A2 is a relative reference.

That means that if you copy Z2, and paste it in say, Z5, Z5 will contain A5.

By the way, you can also "paste down" a formula by selecting Z2, putting your mouse over the lower right corner until you see a 'handle', clicking and holding while dragging downward as far as you need. (that is how I would do it).

By the way, if you had ="X-" & A$2 and did the same thing, you would get the same value in every cell.

So, in Z2,
Enter:="X-" & A2

Now highlight, and look for the 'handle' in the lower right corner.
Drag it down 6000 rows or however far you need.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,416
Messages
5,511,210
Members
408,830
Latest member
AndyDow

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top