Date: 06/07/05 (Microsoft Windows)    Keywords: no keywords

hello, i'm new. and i'm so pleased to have found you :-)

i've been using excel a tremendous amt in my relatively new job... i'm pretty good w/ it but i know there's a lifetime's more knowledge i could accumulate. i'm trying to work on that accumulation now. ;-)

so first a specific question...
i have a column of cells (column A) with a combination of letters/#s, but i would like to strip out the letters and sort by the #s. The problem is, the numerical code in each cell is prefixed by one word in some cases, in other cases, two words. so if i use the text-to-column feature to separate the cells at the space, i get some of the #s in column B, some in column C (where there are 2 words preceding the #). [hopefully this is making sense so far -- i fear i'm making this explanation excessively complex.] is there a merge perhaps, such that i can get the data from columns B & C to combine into one column?

thank you :-)

Source: http://www.livejournal.com/community/ms_windows/35054.html