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
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,133,387
Messages
5,658,518
Members
418,451
Latest member
KarlP

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top