Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Quotations
Got it thank you so much.
Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separate 5digits by inserting - | Excel Worksheet Functions | |||
help with inserting a cell value into a named formula | Excel Discussion (Misc queries) | |||
Excel Limitation - Inserting Colums - Help | Excel Discussion (Misc queries) | |||
inserting rows through external data source | Excel Discussion (Misc queries) | |||
Inserting Footer - Ajit | Excel Discussion (Misc queries) |