I am using Excel 2007-

This is my data:

Carat Gem Weight Clarity Column4
1 2.2 SI1
1.5 2.5 SI2
1.25 2.8 VS1

In Column 4 I need to concatenate the data in columns 1, 2, and 3 into a
table using <td,<tr ...

How do I do this?
Thank you

I believe you're mixing two types of programs...Excel for Spreadsheets and
text editor for editing web pages. HTML does not natively support
concatenating cells. You may be able to do something with JavaScript or
another Scripting Language. Excel concatenates using the "&" operator (in
place of the popular "+" operator) to combine strings.

"urlocaljeweler" wrote:

I am using Excel 2007-

This is my data:

Carat Gem Weight Clarity Column4
1 2.2 SI1
1.5 2.5 SI2
1.25 2.8 VS1

In Column 4 I need to concatenate the data in columns 1, 2, and 3 into a
table using <td,<tr ...

How do I do this?
Thank you