concatenate tables into html tables

[urlocaljeweler]

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

 

[Ms-Exl-Learner]

Use any of the below formula which one is convenient for you.

=A2&" (Your Character) "&B2&" (Your Character) "&C2

OR

=CONCATENATE(A2," (Your Character) ",B2," (Your Character) ",C2)

The Characters you are mentioning within the Double Quotes (“) will be shown
in between the result of cell references.

Remember to Click Yes, if this post helps!