Re: $$Excel-Macros$$ Trim first 8 characters off a cell

2010-07-01 Thread C.G.Kumar
You can use Mid formulae. By the way you are On Mon, Jun 28, 2010 at 10:25 PM, Nadine S n8dine4ma...@yahoo.com 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 --

RE: $$Excel-Macros$$ Trim first 8 characters off a cell

2010-07-01 Thread Dave Bonallack
=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

Re: $$Excel-Macros$$ Trim first 8 characters off a cell

2010-06-29 Thread Chandra Gupta
Please send the example file. Thanks On Mon, Jun 28, 2010 at 10:25 PM, Nadine S n8dine4ma...@yahoo.com 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 --

Re: $$Excel-Macros$$ Trim first 8 characters off a cell

2010-06-29 Thread Satti Charvak
=MID(A1,9,99), assuming data is in cell A1 On 28 June 2010 19:55, Nadine S n8dine4ma...@yahoo.com 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 --