Extracting specific data from a single cell

Giganews Newsgroups
Subject: Extracting specific data from a single cell
Posted by:  Richard Layzell (RichardLayze…@Hotmail.com)
Date: Tue, 14 Oct 2003

I need to extract numerical data from a cell that contains
a numerical and text data mix.

Example:
Cell A1 contains: 1234.00eur

I want to seperate the 'eur' so that I am left with 1234.00

I know about the 'text to colums' function and this does
work- but only for the cells that have an equal number of
digits.  i.e. '1234.00eur' splits to '1234.00' and 'eur'
however 123456.00eur splits to '123456.' and '00eur'.

Can anyone help me?  I just need to know how to split or
ignore the last 3 letters of a list of cells.

Many thanks in advance,

Richard

Replies