Re: Cut and paste part of a string in VBA

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/