- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- Extracting specific data from a single cell

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

- Extracting specific data from a single cell posted by Naz on Tue, 14 Oct 2003
- Re: Extracting specific data from a single cell posted by JMay on Tue, 14 Oct 2003