Topic:Solved MS Excel - Merging two text cells Remainpoint:0
   
PostTime:12/16/2008 4:05:16 PM FloorTop
Lv is 1
Avatar
Level:
1
Professional point:
6
Experience:
1
Thread:
288
Post:
960
Total online time:
1M
Joined date:
4/28/2007 10:58:00 PM
Last Visit:
12/17/2008 12:46:54 AM
Status:
Offline
Hey guys

Its been a long time since I have used Excel for fancy stuff. Is there a way to merge 2 cells in one with just text? For example A1 has the word Tech, A2 has the word Support, and A3 would be the cell with the merge, so the value will be TechSupport?
 
     
   
Gender PostTime:12/16/2008 5:10:12 PM Point:0 | Floor# 1
Lv is 2Lv is 2
portrait
Level:
2
Professional point:
1
Experience:
53
Thread:
308
Post:
995
Total online time:
53M
Joined date:
4/28/2007 10:52:00 PM
Last Visit:
12/16/2008 11:36:38 PM
Status:
Offline
This is the workbook.
 
     
   
Gender PostTime:12/16/2008 6:40:34 PM Point:0 | Floor# 2
Lv is 1
portrait
Level:
1
Professional point:
62
Experience:
12
Thread:
287
Post:
938
Total online time:
12M
Joined date:
4/29/2007 2:35:00 AM
Last Visit:
12/17/2008 12:42:43 AM
Status:
Offline
Quote:
Originally Posted by OBP
HI, place this in a3
= a1 & " " & a2
Thanks for that, although it comes up with an error. I changed it to =a1&a2 and that worked fine.

Thanks again
 
     
   
Gender PostTime:12/17/2008 12:14:27 AM Point:0 | Floor# 3
Lv is 1
portrait
Level:
1
Professional point:
98
Experience:
2
Thread:
272
Post:
982
Total online time:
2M
Joined date:
4/28/2007 11:38:00 PM
Last Visit:
12/17/2008 12:23:56 AM
Status:
Offline
Odd, this is what is in my cell c1.
=A1&" " &B1

I used it to get the space between the 2 words.
 
     
   
Gender PostTime:12/17/2008 12:56:34 AM Point:0 | Floor# 4
Lv is 1
portrait
Level:
1
Professional point:
6
Experience:
1
Thread:
288
Post:
960
Total online time:
1M
Joined date:
4/28/2007 10:58:00 PM
Last Visit:
12/17/2008 12:46:54 AM
Status:
Offline
Probably it's me then. I tried it again and it worked this time.

Thanks again
 
     
1

Sorry, you are not login, click here to login

 

About us | Advertise | Contact us | Partner | Bug Report|Suggesting box|Donation
Home | Forum | Affiliate program| Remote help | Setting | Search | Document | Help | Download|Message

 

Start new topicAdvanced search