Text in cell except last 3 characters

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Barbara Wiseman" <barb24@REMOVE THISgooglemail.com>
Date: Mon, 23 Oct 2006 08:44:22 +0100

Hello,
I have a spreadsheet with text in cells in one column, these vary in length
from 8 to 20 characters, and they are a mixture of numbers and alphas.
What I need to do have a formula in another column which takes each of
these, but with out the last 3 characters. There is no one structure to the
cells either, the placement of numbers and alphas is not uniform
I have played with several of the text formulae, but not hit on the answer,
does anyone have any ideas how I could do this.

Example

3H2ERG5HJ123 should be 3H2ERG5HJ in another column
6ND3002TRV should be 6ND3002 in another column

Barbara.

.

Follow-Ups:
- Re: Text in cell except last 3 characters
  - From: Niek Otten

Prev by Date: Re: How to Identify Changes In Two Work Sheets
Next by Date: Re: Hide multiple rows when particular cell is zero
Previous by thread: Access to a email attachement from excel
Next by thread: Re: Text in cell except last 3 characters
Index(es):
- Date
- Thread

Relevant Pages

Re: change zoom based on column width
... In this spreadsheet, column N ... So, the characters in cell N1, ... containing the string "Assitant Director to the Managing Editor of Regional ... When I manually widened the column, the characters in the cells containing ...
(microsoft.public.excel.misc)
Re: Text in cell except last 3 characters
... | I have a spreadsheet with text in cells in one column, ... | from 8 to 20 characters, and they are a mixture of numbers and alphas. ...
(microsoft.public.excel)
Re: change zoom based on column width
... In this spreadsheet, column N ... So, the characters in cell N1, ... containing the string "Assitant Director to the Managing Editor of Regional ... When I manually widened the column, the characters in the cells containing ...
(microsoft.public.excel.misc)
change zoom based on column width
... Someone sent me a spreadsheet with a formatting trick applied that I would ... So, the characters in cell N1, ... containing the string "Assitant Director to the Managing Editor of Regional ... When I manually widened the column, the characters in the cells containing ...
(microsoft.public.excel.misc)
import or link from Excel disfunction
... In an Excel XP spreadsheet I have three columns of text information ... several of these cells contain more an 255 characters. ... I've tried importing to an existing table where I've changed the field ...
(comp.databases.ms-access)