quotation

In my excel sheet, I have data like "","2,878","-51","58","202.89","3,935.80","40.65","50","3,910.95","3,927.95","50","14,250.00","5,050","0.40","0.45","7,400","0.10","0.40","106.60","2,665","-28","8,595","" I want to delete the comma within the number, for example in the above example the...

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.

Hi, This formula works when it is in the worksheet but when I try to transfer it to VBA I am missing something with the quotation marks etc. Any assistance appreciated. I'm sure it is a quick fix for the right person. Thanks Ryan "=IF(RC22="""","""",IF(HLOOKUP(RC22,INDIRECT("'CATEGORY...

I am trying to remove the double quotation marks from the front and back of the result of this API call: =IF(A1="","",IFERROR(WEBSERVICE("https://api.iextrading.com/1.0/stock/"&A1&"/quote/companyName"),"")) Where the contents of A1 are any stock symbol, like AMZN The API call works perfectly...

i am finding it difficult to add the multiple selected data of the listbox along with other textbox data in sepereate rows for the same quotation. kindly help me,i can share the workbook

Hi all, I am newly registered on the forum, but have been using it to solve my problems for a long time now. I haven't been able to find a solution to my problem on this occasion however. I have a spreadsheet whereby I need to add a certain number of months onto the quotation validity period...

I'm trying to get excel to put a formula into a cell. This works fine with text and simple formulas. Sheets("Sheet1").Range("D11").Formula = "=SUM(A1:A20)" However I need it to print the following into the cell ad the quotation marks are giving me errors. Sheets("Sheet1").Range("D11").Formula...

Hi everyone. Thank you for taking time to look at my post. I will explain my predicament in detail. End result : create a fillable excel form/calculator which will automatically extract data from certain cells to fill a genetic quote template. My plan : 1. Create a fillable data form...

Using excel 2010 I have the following line of code. Range("D13") = "(6) 1 1/4" Screws" I want range D13 to say the following: (6) 1 1/4" Screws I want the single quotation mark after 1 1/4 to be displayed since it's denoting inches. But I keep getting a debug. What do I need to add to...

If the contents of a cell start with ', I'm trying to change them using VBA - the first step being to delete the single quotation; however, I'm having trouble getting VBA to recognize the single quotation in the below If statement: If Left(cel.Value, 1) = "'" Then ..... - I tired cel.text as...

I'm using the indirect function with this formula, =INDIRECT($A$3&"$NKW4") $A$3 is a reference to a sheet name and "$NKW4" is a reference to a cell on that sheet. Is there a way that I can put "$NKW4" into the formula without the quotation marks "". I'm looking for this because when I drag...

Hi Guys, In excel I save the file type as "Test". Putting quotation marks around Test allows me to save the file type as a basic file. Through VBA i'm unable to get this to work correctly Example save path C:\Temp\Testing"Test" This gives me an error and i believe in may have something to...

I am trying to create a macro that consolidates multiple excel spreadsheets. Now this macro will be ran everyday so the save date varies and the spreadsheets that I am copying are in a share drive. My approach to doing this was to open a new spreadsheet save it as today's date and call the other...

Hello friends, I am new here but i need your help for a excel sheet that i am making. I have the City and the Weight in one sheet. In the other sheet, theres the cities, all weights and the costs. In the first sheet, we can select the City and the weight. I want to show in that same sheet the...

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

<TBODY> Appreciate it in getting assistance with the Formula in XL2010 for <o:p></o:p> Rate (Sell D11) calculation for different Venders, Products and Sizes.<o:p></o:p> The margins (profit percentage over the cost price) are different<o:p></o:p> for each Vender. The Venders and Products...

XL10 Quotation Margin Auto Calculation Formula <o:p></o:p> Appreciate it in getting assistance with the Formula in XL2010 for <o:p></o:p> Rate (D11) calculation for different Venders, Products and Sizes.<o:p></o:p> The margins (profit percentage over the cost price) are different<o:p></o:p> for...

Hi everyone I'm Josh new here I'm designing a quotation sheet that has to have validation so incorrect data cannot be inputted, this is going to be long-winded but stay with me. I'm trying to create a code in vba that checks 2 cells and clears one if they both don't meet certain requirements...