Combining cell values in a list

  • Thread starter Thread starter Hru48
  • Start date Start date
H

Hru48

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
 
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.
 
Back
Top