Trying to delete info in a cell
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.
|