I have 1 column of information with over a thousand rows of info. I want to
just delete some info in the cell and keep the rest. Anyone have any idea how
to do this? Here's an example of my info:

AABERG 0.000 83.839 38738
AADLAND 0.000 87.245 58868
AAGAARD 0.000 85.690 48524

I want to delete all the numbers. Ay help woud be greatly appreciated.

ASAP Utilities, a free Add-in available at www.asap-utilities.com has a built
in feature that will strip out all numerical characters from a string.

hth
Vaya con Dios,
Chuck, CABGx3



"E2K3Tek" wrote:

I have 1 column of information with over a thousand rows of info. I want to
just delete some info in the cell and keep the rest. Anyone have any idea how
to do this? Here's an example of my info:

AABERG 0.000 83.839 38738
AADLAND 0.000 87.245 58868
AAGAARD 0.000 85.690 48524

I want to delete all the numbers. Ay help woud be greatly appreciated.

Try DataText to Columns then delete the columns you don't need.

"E2K3Tek" wrote:

I have 1 column of information with over a thousand rows of info. I want to
just delete some info in the cell and keep the rest. Anyone have any idea how
to do this? Here's an example of my info:

AABERG 0.000 83.839 38738
AADLAND 0.000 87.245 58868
AAGAARD 0.000 85.690 48524

I want to delete all the numbers. Ay help woud be greatly appreciated.

That last suggestion was right on the money! Thanks!!

"bigwheel" wrote:

Try DataText to Columns then delete the columns you don't need.

"E2K3Tek" wrote:

I have 1 column of information with over a thousand rows of info. I want to
just delete some info in the cell and keep the rest. Anyone have any idea how
to do this? Here's an example of my info:

AABERG 0.000 83.839 38738
AADLAND 0.000 87.245 58868
AAGAARD 0.000 85.690 48524

I want to delete all the numbers. Ay help woud be greatly appreciated.

Hello. I am new at excel to but try hitting f2 to edit the cell and do the
standard select functions and delete functions. hit enter and you are done.
I hope that is accurate.
"E2K3Tek" wrote in message
...
I have 1 column of information with over a thousand rows of info. I want to
just delete some info in the cell and keep the rest. Anyone have any idea
how
to do this? Here's an example of my info:

AABERG 0.000 83.839 38738
AADLAND 0.000 87.245 58868
AAGAARD 0.000 85.690 48524

I want to delete all the numbers. Ay help woud be greatly appreciated.

Select the column and DataText to ColumnsDelimited bySpaceNext.

Select the columns to Skip, which would be all but the letters, and Finish.


Gord Dibben MS Excel MVP

On Mon, 11 Sep 2006 11:31:01 -0700, E2K3Tek
wrote:

I have 1 column of information with over a thousand rows of info. I want to
just delete some info in the cell and keep the rest. Anyone have any idea how
to do this? Here's an example of my info:

AABERG 0.000 83.839 38738
AADLAND 0.000 87.245 58868
AAGAARD 0.000 85.690 48524

I want to delete all the numbers. Ay help woud be greatly appreciated.