concatenate tables into html tables
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 |
concatenate tables into html tables
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! -------------------- (Ms-Exl-Learner) -------------------- "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 |
All times are GMT +1. The time now is 04:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com