Excel Macro to copy text and append [Solved/Closed]

Report
-
Posts
368
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Hello,

I recorded a macro in Excel where I copied the text from one cell and appended that text to the values in several other cells. The problem however is that Excel is not copying that data in new worksheets. It is just taking the value from the first worksheet and pasting that in all subsequent worksheets.

For example:

32-0151-8715
8716
8717
8720
8719

I want to take the first part (32-0151-) and append it to the front of all the cells below. The values will be different (but in the same format) for each worsheet, however Excel is just copying the values from the sheet where I recorded the macro, instead of copying and appending the new data each time.

Another example of data I am trying to copy/paste:

0025901E83B0
0025901E8514
0025901E851C
0025901E83D4
0025901E8604

Trying to copy the first 10 digits above and append to the front of these rows:

B1
15
1D
D5
05


Is there any way to do this?

Thanks!

4 replies

Posts
368
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
for First part use the formula

=CHAR(CODE(RIGHT(B2,1))+1)

*Supoose value 0025901E851C is in Cell B2

and second part use

="32-0151-" & D2

*Supoose Value 8715 is in Cell D2
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

OK, I think I figured out part of it. Now I just need a formula that will add 1 to a alphanumeric value in a cell. For example 0025901E851C would be 0025901E851D.

Also need a formula that will take this value:
32-0151-8715
and add the first two parts to a cell with the last part already typed in.


Thanks!
Thanks!
Posts
368
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
You are most Welcome