I am using the CONCATENATE() function to combine two strings. For example,
"seek " is in A1 and "help" is in A2 and =CONCATENATE(A1,A2) returns "seek
help". The concatenation loses the formatting of the original words. For
example, if "help" is bold, the concatenated phrase does not preserve this.

How can I preserve the font, etc?
Should I be using something other than CONCATENATE()?

B.T.W. The same thing is true of Text to Columns. The text gets correctly
separated, but the fonts get lost.
--
Gary''s Student