|
|
|
|
|||||
|
|
|
|
|
|
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Microsoft Office support MS Office support forum |
 |
|
|
Thread Tools |
07-17-2008, 11:17 AM
|
#1 (permalink) |
|
Registered User
Join Date: Jul 2008
Posts: 1
OS: xp
|
excel 2003
Hi,
I would like several cells from the same row to be merged into one. The function "CONCATENATE" is doing this. But the problem is that it puts them one after the other, whereas I would like to have a space between them. ex. (those names are in their own respective cells): Acer rubrum trilobum becomes (with the function CONCATENATE): Acerrubrumtrilobum whereas I would like it to be (all in the same cell): Acer rubrum trilobum How can I add a space? I am only aware of a function that gets RID of spaces... Thanks |
|
     
|
|
07-17-2008, 01:49 PM
|
#2 (permalink) |
|
Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic
|
Re: excel 2003
Hi and welcome.
You need to add the space using quotation marks - for example =A1&" "&B1&" "&C1 assuming your words were in cells A1, B1 and C1. I would use the ampersand rather than the Concatenate function for this.
__________________
Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums.   Ad-Aware::SpywareBlaster::SpyBot::SpywareGuard::SnoopFree::AVG Free::HOSTS File::HijackThis::Donate::5 Steps For Infected PCs |
|
|
|
|
| Thread Tools | |
|
|
