is there someway to select what i have "found"?
 

hello,
is there a way to select multiple cells based on the text contained within
them?
i can use "find" to find what i am looking for, but i can not seem to select
all of these cells. i have taken a crash course in naming, formulas, go to..,
filtering and anything else i can try, but nothing seems to work. or it could
just be my brain.

Alternately, is there a way to easily reorganize one huge long column into
multiple columns while maintaining the coherence of the data groups. IE the
long column contains sets of text in several cells like a1 through a6, then
the next set is a8 through a12, etc. But i need to have these groups in
columns next to each other.
i am just learning about macros and such, so i do not know if i can
accomplish anything to advanced.
do not know if i am making sense with this as i am fairly loopy right now.
any help would be appreciated.
thnx

Hi 1stpope,

Try this... If you do a find and click on "Find All", you should see
the dialog expand to show a list of the cells. The first of these will
be highlighted. Scroll down to the end of the list, hold down the Shift
key, and click the last cell listed. You should now see that all your
"found" cells have been selected. At this point you can close the
dialog and dow what you need to do.

As for the column reformatting, that would take some VBA and some
understanding of what defines your groups. It might be complex...

Regards,

Gary