Forum Discussion
Solved
How can I seperate from 1 column to 2 columns. using function. cant use text to column, no integer o
62 1/2 21/2 11/2 1 1/2 4hd 4 hd 103 1/2 10 3 1/2 31/2 3 1/2 7hd 7 hd 92 9 2 11 11 54 1/2 5 4 1/2 82 ...
That's because you mocked up 11 in both the cells as the desired output in your sample file, refer to the cells X10 and Y10 in the sample file, and that confused me.
I have tweaked the code in the attached.
That works perfect thank you!!! Would you be willing to answer another question for me? I'll pay you for your time. I am trying to set up a web query that embeds in excel and updates automatically or with button push, but I keep getting error message. here is url I'm trying get jockey stats to update daily from website without copy and pasting into excel program
http://www.equibase.com/stats/View.cfm?tf=meet&tb=jockey&rbt=TB
Alan Skelly The helpers on this forum are all volunteers. Please don't offer paying them.