ExcelBanter - View Single Post

FreezingInFargo

"Don Guillett" wrote:

on row 1 copied down
="1030 33rd st #"&ROW()

or a macro
for i = 1 to 400
msgbox "1033 33rd St, #" & i
next i

--
Don Guillett
SalesAid Software

"FreezingInFargo" wrote in
message ...
I want to automatically generate a sequence of numbers for apartment units
to
merge with word. I have to do a mailing list to hundreds of apartments. I
type in, say, 1030 33rd st #1, but when I do the fill series only the 1030
generates the series 1031,1032,1033 etc... I've tried to setup the unit
numbers in a separate collumn, but I cant edit the address block in word
to
merge the 2 columns on the same line in the address block.
Any help with how to exclude part of the address or otherwise only
increase
the series of the Apartment unit only would be greatly appreciated?

Don, How would I modify the formula to use it with letters, A thru M e.g., instead of apt. numbers?