Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I am using office 2003, and I try the following: in range(a1:a:20) I have something like "123uiun" but not always the same number of string character or number character, they can be also "1hjjll". I want to separate string and the number. How can I do this using VBA? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text string to Numeric string | Excel Discussion (Misc queries) | |||
Find Numeric sign in a string | Excel Worksheet Functions | |||
How do I replace last numeric string from a alphanumeric string? | Excel Discussion (Misc queries) | |||
doesn't recognize fraction in string as numeric | Excel Programming | |||
Find numeric value at end of string | Excel Worksheet Functions |