Combining cell values in a list
 

Hey all,

How can I write a sub to combine the values of two different cells?

eg cell A1 = '04' and cell B2 = 'BOB BROWN'

desired output being a cell '04 BOB BROWN'

This is to be used for a list of values the length of which will
change each time i refreash it.

Many Thanks,

Hayley


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=498759

Combining cell values in a list
 

If it is always two cells, but with different length strings in them, then
there is no need for a Sub; a worksheet formula like:

=A1&B1

will do.

--
Kind regards,

Niek Otten

"Hru48" wrote in
message ...

Hey all,

How can I write a sub to combine the values of two different cells?

eg cell A1 = '04' and cell B2 = 'BOB BROWN'

desired output being a cell '04 BOB BROWN'

This is to be used for a list of values the length of which will
change each time i refreash it.

Many Thanks,

Hayley


--
Hru48
------------------------------------------------------------------------
Hru48's Profile:
http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=498759

Combining cell values in a list
 

thanks alot


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=498759