How To Replace Double Prime (")

Oct 2, 2013

I have one report that cannot include some special characters so I replace them with empty space. I need also to exclude symbol double prime ( " ). Below is my code, but third line is wrong of course three double primes in a row (two to define text and one is symbol I want to remove), VBA doesn't recognize it. So how could I define that this program also replaces " with space.

Code:
Sheets("Stavke").Range("C2:C" & LR).Replace What:="+", Replacement:=" ", LookAt:=xlPart
Sheets("Stavke").Range("C2:C" & LR).Replace What:="#", Replacement:=" ", LookAt:=xlPart
Sheets("Stavke").Range("C2:C" & LR).Replace What:=""", Replacement:=" ", LookAt:=xlPart

View 2 Replies


ADVERTISEMENT

Replace Double Carriage (returns) With Single

Apr 14, 2008

Is it possible to replace double returns with single?

View 9 Replies View Related

Smallest Prime Factor Of A Number

Apr 14, 2009

Is there any formula witch i can use to find the smallest prime factor of a number?

Example: In A1 i write 30 (30=2*3*5 (the prime factors))

in B1 i write a formula, and the result will be 2 (smallest prime factor)

What is the formula?

View 7 Replies View Related

Prime Factors Regardless Of Number Length

Jan 29, 2010

Searching through the forums, I've found a post of daddylonglegs, witch shows how to find the smallest factor of a number:

View 7 Replies View Related

Finding Prime Numbers In A Range And Highlighting It

Oct 28, 2013

How can I find prime numbers in a range and highlight it if a number in a cell is a prime.

View 9 Replies View Related

Determine If Number Is A Prime Number

Sep 25, 2009

I have a column of random number in Column A and need a formula to identify if any of the numbers in Col A is a prime number. If it is, then say "Prime" in the cell adjacent to the prime number in Col B. Eg if A12 has a value 17, then cell B12 should say "Prime".

View 9 Replies View Related

Test If Number Is Prime Number

Aug 29, 2007

i'm looking to determine if a number is prime or not...

i thought of testing with the mod function in an adjacent cell...but i'm not sure how to do...?

View 9 Replies View Related

Excel 2003 :: Find And Replace Missing The Ability To Replace Values?

Feb 5, 2009

This problem has come up fairly frequently lately, and I'm not sure how to fix it, or if this is by design...but in Excel 2003 I can't seem to do a "Find and Replace" based on the value of a cell. I can do a find, based on cell value, but the moment I change to the replace tab, the "values" and "comments" are missing from the "look in" dropdown.

I've only noticed this when I'm trying to replace on a filtered list, so I'm not sure if that is part of the issue.

Perhaps an alternative way of arriving at the same goal. Basically I have a worksheet with a number of filtered columns. They are filtered just right, using custom filtering, and so I do not want to undo the filters. In some columns I have formulas that are returning #VALUE! errors. I'd like to replace all of these cells with NA.

View 6 Replies View Related

Find And Replace To Not Replace Characters Found As Wildcards?

Jul 2, 2013

I recently became owner of a spreadsheet with some issues, and I am trying to make it useful. Each row has a URL of a blog post, and I want to extract the date from it (which is present in each URL) while getting rid of the rest of the URL. I was able to get rid of everything up to the year (which comes first), but then the URL continues, for example, 2013/05/16/the-rest-of-the-url/ and I would like to just have 2013/05/16 remain.

I am trying to use find and replace with the find box reading 2013/??/??/*/ and replacing it with 2013/??/?? which effectively erases everything else in the url, but leaves ?? instead of the numbers. Is there any way to have it so that it keeps whatever was in the original box?

View 4 Replies View Related

Doing Find / Replace Not Working If Replace Text Is Too Large

Feb 5, 2014

[Code] .....

Trying to repeat a 550 or so character statement with a find/replace however I am getting type mismatch errors. When I use a smaller message in the "replace" it works.

I need it to post a message exactly as long as what I have in there. How do I get it to work?

View 6 Replies View Related

Catching Errors When Using The Find / Replace Function / Replace All

Apr 20, 2006

Need assistance with the code for catching errors when using the find / replace function in excel? In particular, I am trying to write code to break to an error message when the value or string searched for isn't found in the find / replace. At the minute I have just copied the standard code using a macro and all this does is return a message box saying X entries replaced.

View 3 Replies View Related

Search And Replace: Loop To Look Up Xxx And Replace It With The Values Consecutively In Row C

Jun 15, 2006

I have values in row A and I have values in row C. I want to create a loop to look up xxx and replace it with the values consecutively in row C. Look at example for a better Idea. I found a way to find and replace, but I not sure how to use it with qoutes. I was thinking maybe I dont even need row A and just supply a list and excel could have the chunk of data in the code itself.

View 2 Replies View Related

Find, Replace With And Then Replace Adjacent Cell

Mar 18, 2009

I am trying to create a macro where it finds a a certain word in a column for example C. What i want it to do is find anything that says FWD_EUR and then replace that cell (e.g C2) with CASH_EUR_FWD and after it has done that it replaces the adjacent cell (e.g. D2) with EUR_FWD. I then want this to do the same with FWD_USD to CASH_USD_FWD and adjacent cell to USD_FWD.

View 2 Replies View Related

Using Replace Function To Replace ANY Date

May 22, 2013

I'm wanting to use Excel's built in replace function to replace ANY date with "Call:"

I'm not going to go into details about why, but I cannot use a code, as I only want to change them at specific times.

The dates are currently formatted as 12/09/2009. So I need to change the 12/09/2009 and any other date there may be to "call:" without having to go through every possible date.

View 9 Replies View Related

Search And Replace Replace The Whole Cell

May 18, 2009

I have over 16000 cells with different information in them, each cell is unique. There are parts of these cells that have similar information.

I am looking to search part of the cell, and replace the whole cell with my new description, so I can run pivot tables on it.

View 9 Replies View Related

Replace, Copy Then Replace Again

Jan 22, 2007

I used the following code to replace " characters to !%. Then I copy the selected cells, and replace the !% back to "-es. The copied cells contain the "-es. When I comment the second replace, the function is working correctly, the copied cells contain the !%. What's the problem of my code?

Selection.Replace _
What:="""", Replacement:="!%"

Selection.Copy

'Selection.Replace _
' What:="!%", Replacement:=""""

View 2 Replies View Related

Double Sum If

Mar 25, 2009

Let me show you how my sheet is set up.

Steeves 10 ny
Steeves 15 ny
Steeves 20 nv
Steeves 5 tn
Steeves 10 ca
Keppler 16 tx
Keppler 20 nj

Now for this example I need to sum column B if A=Steeves and C=NY.

In this example it would return 25.

View 9 Replies View Related

Double Inequations

Nov 24, 2008

Is it possible to enter double inequations? Excel returns "false" even it is obviously true. If I type =1<2<3 the result is "false".

I can get the correct result using =and(1<2,2<3), but that makes it longer, and if I have more formulas inside instead of numbers I'll have to repeat the middle one, it will take the place, but only in oreder to compare it again.

Is there anything that can be done with this?

View 6 Replies View Related

Is It Possible To Have A Double VLookup?

Aug 19, 2009

On one sheet I have an array of 4 cols. It looks like this:

123 Chris 12345 Jones
123 Chris 23456 Pete
123 Chris 34567 John

On the main sheet there are also 4 cols. In cell A1 I enter a number, in A2 I have a VLookup to get the corresponding name for the number entered in A1, which works fine, I type 123 in A1 and get Chris in A2.

In a perfect world I would like A3 to become a dropdown with 12345, 23456 and 34567 so the user could then select one of those, and by doing so, A4's VLookup would give Jones, Pete or John.

I don't think a dropdown can be populated this way - am I stuck using VBA?

View 9 Replies View Related

Double Spacing

Nov 16, 2006

I have a list with fractions such as 25 1/4, 33 5/16, 20 15/16, etc. i have them formatted as FRACTIONS 2 DIGITS 21/25. Manny of those have double spacing ex: 25 1/2, So i am wondering if theres a way to take the extra spacing off the ones that have double.

View 10 Replies View Related

Double Loop

Oct 21, 2007

I am attempting to create some code that has 2 loops in it.

THE SITUATION:

I will have 2 ranges (eg B54:B100, and B106:B149 - the problem is I will arrive at these ranges by code such as: Range(Selection, Selection.End(xlDown).End(xlDown)).Select)).

WHAT I THEN REQUIRE

I need to have some code that will look through each cell in the second range and if the cell contents is found in the first range then the entire row from the second range will be deleted.

View 9 Replies View Related

Double Vlookup

Aug 26, 2008

I have a double vlookup problem here.

Here's a simple illustration:

A B C D E F G
1 1 1 1 One
2 2 2 2 Two
4 4 3 3 Three
3 3 4 4 Four
5 5 5 5 Five

I need to match A,B with E,F.

If they match, I need to display the string in G in C.

View 9 Replies View Related

Double Lookup

Jan 16, 2009

=INDEX('sqft - PC each bldg'!D2:D1705,MATCH(Sheet5!B3&Sheet5!F2,'sqft - PC each bldg'!A2:A1705&'sqft - PC each bldg'!C2:C1705,0))

my result is N/A

I wonder if it has to do with both lookup ranges being columns?

View 9 Replies View Related

Double Condition, Or Else

Jun 19, 2009

Have a quick one, trying to figure out a simple expenses/income/saving tracking table for my wife and in-laws; have figured out most of it. Will use pivot to extract most of the data, but on a summary sheet I need double condition sums (or at least I guess so...). For example I have "amount" column (which is expanditure) and date column (have used function to extract month and year for other purposes to separate columns), how can I calculate multiple costs (all the costs/expenditures in a month) that have taken place in eg. april 2008 only/ since I want to display it on a separate sheet as a summary overview...here's the link to imageshack, dunno if it's gonna work:

[url]

Have tried something like: =SUMPRODUCT(month="4")+SUM(amount) but it sums up the entire column...

or this one: =SUMPRODUCT(ISNUMBER(MATCH(4,month,0)+SUM(amount)))
I know I miss a bunch on the last one

View 9 Replies View Related

Double Lookup For Name/Value

Jan 13, 2010

I have a list like this:

xxxxxxxxxx1-jan | 2-Jan | 3-Jan
-------------------------------------------------
Location 1
Bob Smith ----B2--- C2 ---- D2
Frank Thomas-B3---- C3---- D3
Location 2
Bill Clinton----ETC ALL
George Clinton

And another sheet, a similar list, (just names and randomly sorted) but populated with the values I want,

xxxxxxxxxxx1-jan | 2-Jan | 3-Jan
-------------------------------------------------
Bob Smith --- 2 -----5------ 1
Frank Thomas 3----- 1 ------2
Bill Clinton ----4----- 5 ------2
George Clinton 4----- 4 ----- 4

I want to check the name in A2 on the first sheet against all of column A on the second sheet, then find the number value for the correct day for that name.

How can I write a formula that will look up these values for me? I looked at OFFSET but unfortunately I don't have a lot of excel experience (yet)

View 9 Replies View Related

Double Values For VLOOKUP

Mar 28, 2014

I have a calendar (tab March in the attached file) where I can indicate the delivery package of tab List. The problem that if the delivery happened twice a day, only the first one will be indicated. If there is any way to indicate both deliveries?

View 2 Replies View Related

Avoiding Double Counting?

Apr 7, 2014

I am trying to avoid double counting two separate rows with the same columns. For example:

StockFund AFund BFund CFund DFund EFund FFund GCountDesired Count
LKOH111100044
LKOH001111042

If I have two stock codes the same in column A (not necessarily one below the other), I only want to count one of the occurrences per fund. So I would like to avoid counting the duplicate records for funds C and D. The desired outcome for the total holdings of LKOH should be 6 and not 8.

View 2 Replies View Related

Double Lookup Values

Feb 17, 2009

I am trying to lookup the value that corresponds to three sets of data. The formula I have been using is but I am still getting #NA. I’ve attached the spreadsheet

=INDEX($B$3:$I$17,MATCH($B21,$A$3:$A$17,0),MATCH($A$22,$B$1:$I$1,0)+MATCH($B$20,$B$2:$E$2,0)-1)

I am looking to search Vendor name 1, Actual and A to return the value of 1.

View 2 Replies View Related

Double Click Event

Jun 11, 2009

I am trying to write some questions on cells of Sheet1 of a workbook. Then I want to write the answers on cells of Sheet2 of the same workbook. I want the user to be able to double click the question-cell on Sheet1 and be taken to the respective answer on Sheet2.

View 6 Replies View Related

SUM Function And Double Click

Sep 30, 2009

I have a spreadsheet that just uses the basic "SUM" function. This morning I went to use it and the function does not work after I change a number within the field of that function. If, however, I go into the SUM function and double click, then hit enter, it does the new calculation.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved