combining cells

ttowncorp

Board Regular
Joined
Feb 2, 2015
Messages
174
Office Version
365
Platform
Windows
is there a way to combine two cells info into one? if cell "A" has the word "happy" and cell "B" has "feet" cell "C" will say happy feet.
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

ttowncorp

Board Regular
Joined
Feb 2, 2015
Messages
174
Office Version
365
Platform
Windows
thank you that works perfect.
 
Last edited:

ttowncorp

Board Regular
Joined
Feb 2, 2015
Messages
174
Office Version
365
Platform
Windows
quick question, some of my cells have time and dates in them but they are coming out as a long number is there a way to keep the time to be like "happy feet 1/24/2019 12:16pm" instead of "happy feet 41242.3215
 

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
6,058
Platform
MacOS
Try

=A1&" "&B1&" "&TEXT(C1,"dd/mm/yyyy hh:mm am/pm")

Code:
[TABLE="width: 673"]
<colgroup><col width="87" span="2" style="width: 65pt;"><col width="151" style="width: 113pt;"><col width="87" span="4" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="width: 87"]Happy[/TD]
[TD="width: 87"]Feet[/TD]
[TD="class: xl63, width: 151, align: right"]24/01/2019 12:16 pm[/TD]
[TD="width: 87"][/TD]
[TD="width: 261, colspan: 3"]Happy Feet 24/01/2019 12:16 pm[/TD]
[/TR]
</tbody>[/TABLE]
 

Watch MrExcel Video

Forum statistics

Threads
1,095,621
Messages
5,445,553
Members
405,338
Latest member
Justmor

This Week's Hot Topics

Top