Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I not use a " in a formula?
Lets see how I can explain this. I have HTML code in cells that is the same for every cell except a few spots in the code. So i want to pull this info from other cells. So I was trying to use a formula like this: ="<br clear="all" "&A2&"<table width=100%" but the code gets messed up at the first " in my code. Any other way we can think of getting around this. I've done this manually for over 7000 items and I'm sure I still have 20,000 more to go. Thanks ExcelForum! -- Chuck N ------------------------------------------------------------------------ Chuck N's Profile: http://www.excelforum.com/member.php...o&userid=27057 View this thread: http://www.excelforum.com/showthread...hreadid=536825 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I not use a " in a formula?
Chuck Try one of these approaches: ="<br clear="&""""&"all"&""""&" "&A2&"<table width=100%" or ="<br clear="&CHAR(34)&"all"&CHAR(34)&" "&A2&"<table width=100%" Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=536825 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I not use a " in a formula?
they definetly do work. The HTML is much more complex so i decided to try this and it worked. I inserted a new workbook and broke the HTML up in four cells so the cells read like this on the new worksheet named Code: I did rename my sheets and what I'm searching for to protect identity if it looks strange. B1:=LEFT(CurrentProject!S3798,FIND("Product Name",CurrentProject!S3798)-1) B2:=MID(CurrentProject!S3798,FIND("Model#",Current Project!S3798)+8,506) B3:=MID(CurrentProject!S3798,FIND("Max Size",CurrentProject!S3798)+1,202) B4:=RIGHT(CurrentProject!S3798,32) in the cell that i need the info to go into the code reads like this S3851:=Code!$B$1&C3851&Code!$B$2&Q3851&Code!$B$3&R 3851&Code!$B$4 If anyone needs explanation on how these work i'd be obliged to help as this community has helped me out tremendously. -- Chuck N ------------------------------------------------------------------------ Chuck N's Profile: http://www.excelforum.com/member.php...o&userid=27057 View this thread: http://www.excelforum.com/showthread...hreadid=536825 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |