Re: Cut and paste part of a string in VBA

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: noah (noah.15wfj4_at_excelforum-nospam.com)
Date: 05/07/04 

Date: Fri, 7 May 2004 13:39:06 -0500

I have another code that does that same thing. But what I can't get it
to do; is delete the second 2 from column "J". In other-words, I need
column "J" to have only the far left remaining.
If column "J" has "ABC1" in a string, final result should be: Column
"J" = "AB" and column "L" = "C1".
AND sometimes column "J" will have a 5 character string like "ABCD1".
And then I still want column "L" to only have "D1" and column "J" =
"ABC" in final result.
I probably need to add another command to it......
What do you think? 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • RE: IPCS Clist Evaluate command and character strings
    ... question about the EVALUATE command. ... to extract a character string from the dump for use in a NOTE ... I don't know if when you say "clists" you really mean the old ...
    (bit.listserv.ibm-main)
  • Re: character string assumed length
    ... If I call a subroutine with a given character string and I try to put ... character*8 abc ... subroutine def (abc) ...
    (comp.lang.fortran)
  • Re: Problem when running cut from expect
    ... > The command, when run from ksh, works fine. ... provided when tcl (expect is just a tcl interpreter running the ... This "quotes" the 3 character string "hyphen dee space" as a ... single argument which is then placed onto the argv. ...
    (comp.lang.tcl)
  • Re: Extract substring
    ... I can run the "Dir" command & pipe the results to a text file. ... Extracting strings is relatively simple - but your specification is far too ... We can't determine from your description whether you want precise substrings ... would list that character string. ...
    (microsoft.public.win2000.cmdprompt.admin)
  • RE: Data from an Access 97 table to a Visual FoxPro table
    ... You can make a remote view to see the contents of the data in Access. ... When issue "USE " the view, Issue the next command "GO BOTTOM" to read all ... > I set up an ODBC data source for the FP table and linked to it from Access. ... > message that it can't find some character string. ...
    (microsoft.public.fox.programmer.exchange)