how can i loop a macro

[Guest]

this is my example dry = new rate for dryers dry#### = old rate for
dryers
____________________
dry1052 | 50 |
_______|____________|
dry | 50 |
_______|____________|
dry1152 | 40 |
_______|____________|
dry | 40 |
_______|____________|

this continues.....for about 1500 cells
i want a macro that will combine information, (=a2&""&b2) and makes part of
it, but i also need to get last 2 letters in colum A, onto the combined cell.

i can do everything but get last 2 letters and make a macro, that doesnt
stop until the data stops, not sure if this is possible

thanks in advance

 

[Dave O]

You can do this without a macro, if you'd prefer it. You can parse the
last two letters of an entry with the RIGHT() function. If the word
EXCEL is entered in cell A1, then
=RIGHT(A1,2) returns EL.

Add this to the formula you posted:
=a2&""&b2&RIGHT(A1,2)