try
=LEFT(A1,LEN(A1)-3)
To be sure that you don't get fouled up by leading and trailing spaces, you
can use
=LEFT(TRIM(A1),LEN(TRIM(A1))-3)
"Helen" wrote:
Anyone know how to trim a postcode of variable length, sometimes 5, 6 or 7
characters in length to remove the last 3 characters on the right hand side
of the cell? The postcode is displayed with any gaps or marks and the
separator will varying but it is always the last 3 characters that are
superfluous.
--
Thanks
|