How to combine cells into one

[ZenMasta]

I am trying to map a product list to a template for their my website
ecommerce app.
my product fields don't match up exactly with the website so in some cases I
need to consolidate fields.

I would like take some columns and combine them into one.. but instead of
taking 1,2,3 into 123 I want to add some text and stuff in between... ie,
some of the columns I have are measurements so the numbers alone might be
meaning less.

I'm not really excel savvy but I tried =B2&othercolumns, but the problem
with this is there are no spaces. I tried adding spaces before and or after
tht & and it didn't seem to make any difference.

It would be nice if I could add some custom text in between

ie F2=DesctiptionG2=Length H2=Width I2=Height

So being able to include my own custom text would be handy (ie, html or
whatever else)
Description<br>
<strong>Length:</strong>G2<br>
<strong>Width::</strong>H2<br>
<strong>Height::</strong>I2<br>

Thanks.

 

[VanguardLH]

I am trying to map a product list to a template for their my website
ecommerce app.
my product fields don't match up exactly with the website so in some cases I
need to consolidate fields.

I would like take some columns and combine them into one.. but instead of
taking 1,2,3 into 123 I want to add some text and stuff in between... ie,
some of the columns I have are measurements so the numbers alone might be
meaning less.

I'm not really excel savvy but ...

And how is this an issue with Outlook?

 

[Milly Staples [MVP - Outlook]]

Try asking in an Excel group - this group supports Microsoft Outlook.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375


After furious head scratching, ZenMasta asked:

| I am trying to map a product list to a template for their my website
| ecommerce app.
| my product fields don't match up exactly with the website so in some
| cases I need to consolidate fields.
|
| I would like take some columns and combine them into one.. but
| instead of taking 1,2,3 into 123 I want to add some text and stuff in
| between... ie, some of the columns I have are measurements so the
| numbers alone might be meaning less.
|
| I'm not really excel savvy but I tried =B2&othercolumns, but the
| problem with this is there are no spaces. I tried adding spaces
| before and or after tht & and it didn't seem to make any difference.
|
| It would be nice if I could add some custom text in between
|
| ie F2=DesctiptionG2=Length H2=Width I2=Height
|
| So being able to include my own custom text would be handy (ie, html
| or whatever else)
| Description<br>
| <strong>Length:</strong>G2<br>
| <strong>Width::</strong>H2<br>
| <strong>Height::</strong>I2<br>
|
| Thanks.

 

[Diane Poremsky [MVP]]

you need to insert " " for spaces
= B1 & "" & " " & b2

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Poll: What version of Outlook do you use?
http://forums.slipstick.com/showthread.php?t=27072