If you're trying to concatenate the values in E9, F10 and X99 then the
forumula in B4 would read:

=E9&" "&F10&" "&X99

This puts spaces between each cell value, if you do not want space the
formula would be
=E9&F10&X99

and if you're adding them the formula would be:
=E9+F10+X99
--
Kevin Backmann


"ClaudiainDublin" wrote:

how do I copy text contents of multipe randomly placed cells into one text
cell ?
for example
in Cell B4 I want to reference the contents of Cells E9 and F10 and x 99
How do I do this and display the text correctly ?

Constantly generating error messages when I use
=B33:B34