Hi all, i am having a problem with one of my excel spreadsheet. Hopefully someone out there can enlighten me on this. The situation is like this:

I have cell A1 written as 12mm

and cell A2 written as clear monolithic

and cell A3 written as glass

is it possible for me to have a formula or way to put the three cell into one cell A4 written as 12mm clear monolithic glass. The range and number of words in cell A1,A2,A3 may varies and sometimes it will be longer than usual.

Here's two ways: In cell A4 enter the formula:

=A1&" "&A2&" "&A3

or

=CONCATENATE(A1," ",A2," ",A3)

MIKE

thank you so much mmcconaghy! your method works perfectly fine! i managed to solve the problem now (:

Ask Your Question

Weekly Poll