Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Split Function on String with no spaces
I have a cell address - assume its relative - "DF456". I want to split this
up by colunm address and row address "DF" and "456". I was hoping I could use the Split funciton But I am not sure what delimiter to use if I am going to use the Split function - if its even applicable. Or am I forced to loop through the string find the starting/ending points of Letters/Numbers and use the replace function to redefine (i.e. replace("DF456","DF", "") = "456" and replace("DF456","456", "") = "DF" Thanks EM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to split 922 037 022 into 3cols and recombine without spaces | Excel Worksheet Functions | |||
Find String in another string - only between spaces | Excel Worksheet Functions | |||
Removing Spaces from string | Excel Worksheet Functions | |||
counting spaces in a string | Excel Programming | |||
Count Spaces In A String | Excel Programming |