quotation marks

  1. M

    VBA Not Interpreting Single Quotes Correctly

    Hello, As part of a larger macro, I'm trying to input a formula into a range of cells. This formula does an indirect lookup of a worksheet name as a tab name, and therefore requires single quotes. However, VBA keeps trying to interpret the first single quote as a comment, and therefore...
  2. A

    remove quotation from excel while pasting the data

    Hi All, When ever i'm pasting data from Excel to TXT i'm getting quotation mark (") for each cell. How to remove them. Remember i have copy lot of cell's so i can't use F2 and copy data and paste.
  3. A

    #Value error

    Hi guys Id be grateful if you can help. Im getting a value error on this formula and I cant work out why this is the case The Vlookup returns the value 421 - So Id like the formula to resolve to =ROUND('BlueCross Rates'!U421,3) =ROUND("'BlueCross Rates'!U" &...
  4. Y

    Extract text in double quotes including the the double quotes

    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...
  5. J

    Macro to insert Concatenate formula with "-" between values (using R1C1) Not Working

    Hello, any thoughts on why the below macro is resulting in a runtime error 13? I am trying to concatenate the values in column N and DO with a "-" in the middle. If I remove the "-" it works..... just not sure why I cant put a "-" between the two values. I also tried without "" and it doesn't...
  6. M

    CONCATENATE adding quotes

    Good afternoon, I have a long formula that generates a LOOKUP function from varying sources it is looking for the maximum value in Column I then getting the correlated point in column B, to perform the LOOKUP of the timings in column A, this data is a wave form and I need to find it's initial...
  7. L

    Data Sort ignoring ""

    I have a tab that is pulling data from another part of the spreadsheet and leaves a "" for a blank cell. I need to sort some columns alphabetically & numerically but the "" is obviously showing as a string. Is there a way to only sort the non "" cells? Thanks for your help
  8. F

    CSV Quotation Mark Help

    Hi, I need to export a CSV file from my CRM to be imported into SAGE 200. The problem is that I need string fields to have quotation marks around them. I cannot find a way to have the quotation marks show only, for example, on columns A, C and D. When I try and add them manually instead of...
  9. D

    Adding a line of code to a macro to strip Quotes from the text file created

    Hello - I have, with the expert assistance from a user here, the following code. I need to, however strip the text file it creates of the " marks Excel has decided to add in before I close the file created. Does anyone know how to accomplish this by possibly adding a line of code in? I think I...
  10. M

    Find Function looking for one Quotation mark

    Hello and thank you for your time, I am trying to take a string of text and remove everything after the first quotation mark ("). For instance: ab c "123" def becomes ab c Here is my formula: =left(a1,len(a1)-find(""",a1)) Excel does not like """ I have tried """" and '"'. Quite...
  11. R

    replacing csv text with new text

    Hi all - i'm new to this website, so apologies if i've posted in the wrong place... I have a csv file which i need to open and then in the fourth row replace the following text ! !,0, with " ",0, i.e. replace the ! with " I need to do this in a vba macro and also once the csv...
  12. G

    Removing quotation marks around values

    I have a worksheet containing cells with values enclosed in quotation marks (see attached image). I was wondering how to remove the quotation marks and simply leave the actual value in the cell. e.g. In the image: in cell B2 i have the value "D1", but i want to remove the quotes and just have...
  13. C

    Complex Hyperlink Function

    Hi, in VBA I have Sheets("" & tab_name & "").Cells(1, 2) = "=HYPERLINK("""" & 'Sheet1'!A2 & ""'Sheet1'!A1"""",""To Main Roll-Up"")" tab_name is a defined variable. The code inserts an equation containing a hyperlink function. In 'Sheet1'!A2, I have the current workbook name (ie [Book1])...
  14. J

    Losing Data when Importing from Excel to Access

    I am working in an Access Database and have pasted data from Excel. I did not receive any paste errors, but found that there was a bunch of data missing from the Access table. After reviewing, it appears that the excluded records included quotes in the description field. I figured out how to...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top