how to delete last X number of characters in a cell
 

using XL 2003.

Thanks!!

....Lisa

how to delete last X number of characters in a cell
 

If you want to get rid of the rightmost 4 characters from cell A1, for
example, use this:

=LEFT(A1,LEN(A1)-4)

Hope this helps.

Pete

On Jul 25, 4:05 pm, "
wrote:
using XL 2003.

Thanks!!

...Lisa

how to delete last X number of characters in a cell
 

That did it...thanks!!

....Lisa

On Jul 25, 11:08 am, Pete_UK wrote:
If you want to get rid of the rightmost 4 characters from cell A1, for
example, use this:

=LEFT(A1,LEN(A1)-4)

Hope this helps.

Pete

On Jul 25, 4:05 pm, "
wrote:



using XL 2003.

Thanks!!

...Lisa- Hide quoted text -

- Show quoted text -

how to delete last X number of characters in a cell
 

You're welcome - thanks for feeding back.

Pete

On Jul 25, 4:43 pm, "
wrote:
That did it...thanks!!

...Lisa

On Jul 25, 11:08 am, Pete_UK wrote:



If you want to get rid of the rightmost 4 characters from cell A1, for
example, use this:

=LEFT(A1,LEN(A1)-4)

Hope this helps.

Pete

On Jul 25, 4:05 pm, "
wrote:

using XL 2003.

Thanks!!

...Lisa- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -