hjælp til instr funktionen

og jeg har forsøgt med:
KontoNr = Replace(Range("H6"), "-", "") og
KontoNr = Replace(Range("H6"), " ", "")

tænkte på om man kunne lave en if-sætning ?

Hey,

Can you please send your Visual Basic problem to me in english, thanks

Mail Me : binuyogi@hotmail.com
regards,
binu

well. its against the forum-rules to send email regarding help with a specific question. I can write the probl. here:

I need to remove " " and "-" from this string "KontoNr"... I have tried with the above mentioned. maybe an if-then solution ?

replace(replace(Range("H6") , " ", ""), "-", "")

"jeg har en variabel:"KontoNr" som kan indeholde ..."


So you should use
KontoNr = replace(replace(KontoNr, " ", ""), "-", "")

nice... thnx terry.

your very welcome

Hi Rashid,

Try this one,

        Dim strval As String
        Dim i As Integer
        Dim ipos As Integer
        Dim strvalue As String


        strval = "bi-nu-t v"
        ipos = Len(strval)

        For i = 1 To ipos
            strvalue = Replace(strval, "-", "", 1)
        Next
        msgbox(strvalue)

-> binuyogi
thanx for your reply...
Terrys solution gave me the answer i needed.

Hi Rashid,

  Can you please help me?

I want to know about this site and how it works, i do not know the dutch language, please reply me

can you please chat with me now in gmail or yahoo?
thanks
binu

>i do not know the dutch language

Of course not, it's danish.

course=cause

Hm, nu dur mit E heller ikke mere.

Hi binuyogi.

I appreciate that you want to help the users with their questions, but the rules for this site, state that all communication must happen via this site. Your request to the users to send their question to your email is therefore not the way this site is working.

You might want to try www.experts-exchange.com – it’s problem solving site like this, but it’s in English :)

Best regards.

Snowball / Admin