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.

ZenMasta wrote:

> 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?

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. 

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

-- 
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:dailytips-subscribe-request@lists.outlooktips.net

EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

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


"ZenMasta" <me@nospam.kthx> wrote in message 
news:OUMWRY6dKHA.5136@TK2MSFTNGP02.phx.gbl...
> 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.
>
>