Combining phrase from 3 cell to one

Microsoft Office 2007 professional (aca...
July 5, 2010 at 17:37:31
Specs: Windows
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.

See More: Combining phrase from 3 cell to one

Report •


#1
July 5, 2010 at 18:26:09
Here's two ways:

In cell A4 enter the formula:

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

or

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

MIKE

http://www.skeptic.com/


Report •

#2
July 5, 2010 at 18:43:43
thank you so much mmcconaghy! your method works perfectly fine! i managed to solve the problem now (:

Report •

#3
July 5, 2010 at 20:08:45
Glad I could help.

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question