I have a string similar to the following (the underscore
is a blank space):

_49 x 1.5 Total

49 and 1.5 come from ranges in a worksheet

I need to assign this string to a variable. I tried the
following, but I can't get it to work (doesn't seem to
like the blank spaces):

NewBF = Union(" ", Sheets("PanelChange").Range("C1"), _
" " x ", Sheets("PanelChange").Range("D1"), " ", "Total")

Any advice on this?

TIA,

Todd