hi thanks.

This is the set up and what I am doing:-
B416 BALDWIN C.A. 12617 this should be B416 BALDWIN C.A. 112617

I am tried the formula earlier and it just leaves a 1 in there and when
i do the paste special nothing happens.

Any help would be great

Thanks


--
webfort
------------------------------------------------------------------------
webfort's Profile: http://www.excelforum.com/member.php...fo&userid=7964
View this thread: http://www.excelforum.com/showthread...hreadid=543232