=Right(A1,LEN(A1)-8)
Regards - Dave.
Date: Fri, 2 Jul 2010 09:40:24 +0530
Subject: Re: $$Excel-Macros$$ Trim first 8 characters off a cell
From: kumar.bemlmum...@gmail.com
To: excel-macros@googlegroups.com
You can use Mid formulae. By the way you are
On Mon, Jun 28, 2010 at 10:25 PM
You can use Mid formulae. By the way you are
On Mon, Jun 28, 2010 at 10:25 PM, Nadine S wrote:
> I have a cell that I'd like to write a formula that returns all but the
> first 8 characters. The cell's data can be any length. Thanks.
> Nadine
>
> --
>
> ---
=MID(A1,9,99),
assuming data is in cell A1
On 28 June 2010 19:55, Nadine S wrote:
> I have a cell that I'd like to write a formula that returns all but the
> first 8 characters. The cell's data can be any length. Thanks.
> Nadine
>
> --
>
>
Please send the example file.
Thanks
On Mon, Jun 28, 2010 at 10:25 PM, Nadine S wrote:
> I have a cell that I'd like to write a formula that returns all but the
> first 8 characters. The cell's data can be any length. Thanks.
> Nadine
>
> --
>
> ---
I have a cell that I'd like to write a formula that returns all but the first 8
characters. The cell's data can be any length. Thanks.
Nadine
--
--
Some important links for excel users:
1. Follow us on TWI
