How to combine cells into one

  • Thread starter Thread starter ZenMasta
  • Start date Start date
Z

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.
 
Not sure what you're looking for but here are a couple of examples:

A1 = Check
B1 = This
C1 = Out

=A1&" "&B1&" "&C1

Returns: Check This Out

A1 = 10
B1 = 3

=A1&"ft "&B1&"in"

Returns: 10ft 3in
 
Thanks T Valko, that's exactly what I was looking for. Didn't know I could
use quotes etc.
 
Back
Top