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