Hi
Lets say I have the following going down column A:
Is there a combination of functions I could use to extract the non-numbers to a separate column? For example, my results would be
Milwaukee 1 2 3 4 New York 5 6 7 San Francisco 8 Atlanta 9 10 11
I know how to do via VBA, is there a way using worksheet functions?Milwaukee New York San Francisco Atlanta
Last edited by davegugg; 08-02-2010 at 02:22 PM.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks