Hi - I have a spreadsheet with 2 columns

House Name
House Number

I want to merge these to columns and I have used the following

=B2&" "&C2&" "

This works fine except I want to run a macro that automatically merge
these 2 columns from a helper column I created - the only problem bein
I do not know how many House names or numbers need merging pe
spreadsheet so my macro automatical self calculates 500 rows but th
database these spreadsheets can uploaded in to keeps reading the blan
spaces left behind in the empty rows and failing

Anyone know how to let the macro know when to stop at the last row o
data please

Any help appreciate

--
Steve
-----------------------------------------------------------------------
Steve M's Profile: http://www.excelforum.com/member.php...fo&userid=3252
View this thread: http://www.excelforum.com/showthread.php?threadid=52349