|Was there a point there someplace? If so, I missed it.|
re: "The best answers come when you already have the answer."
You're kidding, right?
I didn't know that the SPLIT function existed until I Googled for ways to convert a column number from a column letter after reading your original post.
All it took was one try, a little reading (during which I learned a few other techniques that will come in handy) and I found the SPLIT function.
Why re-invent the wheel by writing UDF's when functions already exist to accomplish your goal?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.