|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.
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,