Inserting Quotations
I am writing a workbook that I paste into a web page. the problem is I
need each cells contents to be surrounded by quotations is there any way I can have all text in each cell surrounded by quotations without me having to type them in? For example my worksheet goes Day Month Year Start time End Time Event Event description 1 1 2006 12:00 AM 11:59 PM New Years New Years Day Holiday I need the string to look like "1", "1", "2006", "12:00 AM", "11:59 PM", "New Years", "New Years Day Holiday" If anyone can help me this it would be greatly appreciated |
Inserting Quotations
Assuming your information is in columns A thru G, you can write this
formula: =CHAR(34) & A1 & CHAR(34) & ", " & CHAR(34) & B1 & CHAR(34) & ", " & CHAR(34) & C1 & CHAR(34) & ", " & CHAR(34) & D1 & CHAR(34) & ", " & CHAR(34) & E1 & CHAR(34) & ", " & CHAR(34) & F1 & CHAR(34) & ", " & CHAR(34) & G1 & CHAR(34) The CHAR(34) generates the quotation marks. |
Inserting Quotations
Got it thank you so much.
Bob |
All times are GMT +1. The time now is 02:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com