quotes

I have asked this before in this forum (https://www.mrexcel.com/forum/excel-questions/1062061-separating-characters-hyphen.html#post5100161), but have ran into a hiccup. Cell AJ2 has "Khaki" without quotes Cell AJ3 has "Medium Gray" without quotes In cell K2 I have (=SUBSTITUTE(AJ2&"/"&AK2...

Hi all, Looking for a macro to achieve the following. In column AA of a sheet named "Welcome" no quotes, I have various text in its cells. If the cell does not contain the word "facts" no quotes in it, I would like to have that row deleted from ALL sheets in the workbook, and not leave any...

Hello, I am trying to find a way to use VBA to remove these hidden quotes in front and end of a few words in one cell (B1). Can someone please pass on a way to delete or remove the quotes just in one cell? Thank you!

Hi all, I have a code that adds in n number of new worksheets and names it based on cell value. Eventually, I have a summary sheet that will perform lookups to respective sheets using indirect. The newly created sheet names do not have any spaces in them, but for some reason the references...

All, I am in need of some help. I have two workbooks - A acts as a database of all our quotes, whilst B is a local file with just the quote info for that particular job. I am trying to write some VBA to loop through all the quotes in B (unique id in col F) and update the main database. I am...

Hi, I created the below sub to convert a single column of values (of varying amounts) into a single, comma separated string. Thus if Column A on "Sheet1" contains: 50 55 60 65 70 75 The procedure will convert that to a comma separated string on a new worksheet ("List1"), e.g.: 50, 55, 60, 65...

When I use the following, I place the formula into the Spreadsheet and get the resulting row number. Range(emailColumn & FirstRow & ":" & emailColumn & LastRow).Formula = "=MATCH(B2,'RosterFileName'!FullName,1)+3" When I try this function in VBA I get different errors; syntax, compile error...

Hello everybody. I'm importing datas from a website. The datas have "" double quotes, it seems they are normally invisible (I can see them only copying an pasting in a notepad). How can I remove them? I've already tried different ways, unsuccessfully (for example): Dim c As Range...

I'm using Excel 2003. I have an Excel spreadsheet that I'd like to use as a template for quotations for my company. Our quotes manager will enter the information into the spreadsheet, do a "save as" each time he quotes a job. The original sheet will be used as the template. Is there a way to...

Hello Forum, I am in need of getting the totals by month for service types. I have a tab named Spot Quotes, in column R is the Service type, Col 'N' has the date and time completed like this '2/1/2018 13:00' My total tab is named Total Quotes. Starting in cell H4 would be the total for the...

Here's an image: https://ibb.co/hJFWYb Context: I need to get a shipping cost to finalize my quotes. Some quotes are really complicated and long. In the example, I want to return the total qty of Mother boards, Hard drives and 4gb ram. Appreciate the help!

Hi, I need to export a sheet to CSV format, so I can use that csv file as input to a access table SQL insert statement. My problem is, I have one column that has data in it with quotes that cannot be altered. e.g. The "location" field has building, room, cubicle such as "Building 208, Room 19...

I'm pulling in a few hundred real-time stock quotes at once and automatically performing a bunch of sorting and modeling as the data updates, but it often lags badly so that I'm sometimes seeing stale stock quotes (30-60s after they change). I've determined that it's not the real-time quotes...

Hello, I'm trying to add the key classificationLevels with a value of ["Sectors"] (yes, I need the quotes) to a dictionary When I try Body.Add "classificationLevels", "[""Sectors""]" I actually add the following with the extra ""s. ["Sectors"] I also tried Body.Add "classifiactionLevels"...

Excel 2013 macro code snippet: ActiveCell.FormulaR1C1 = "=MID(D2,FIND(""."",D2,1)+1,FIND(""."",D2,FIND(""."",D2,1)+1)-FIND(""."",D2,1)-1)" This formula within the quotes works (I'm using it in another excel file), but when the above code snippet sets the cell value, the actual resulting...

I have a large spreadsheet of data that goes from Columns A to Columns AD and is about 2000 lines. The spreadsheet is created from some Access database (I am not familiar with the process). For some reason various cells end up with quotes at the beginning of the text in the cell (e.g. "USE...

Hello everyone, I am trying to extract text in double quotes including the double no matter what position they occur in. for example: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 219px"><col...

Hello! Sorry for the dumb name of the topic - I am a beginner in excel and I know not that much so it's difficult for me to define the issue here. I attached my excel file which I am referring to. It's kinda difficult to explain what I wanna do here but I will try. What I wanna do here, is...

Can someone explain why in the formula: =COUNTIFS(Sales,">="&H1,Sales,"<"&G2) quotes are used? I know about concatenation but why are the logic signs in quotes and why couldn't the formula just as well be written as: =COUNTIFS(Sales,>=&H1,Sales,<G2) ??? I know words that appear in quotes...

I need some help for when I am copying data from a cell and pasting it into a text box on a website. Every time I copy the cell and paste it, it has quotes at the beginning and end of the data string that I have to manually delete. Is there a way to do this so it does not paste the quotes...