Thank you very much
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Paul Schreiner
Sent: 29 November 2012 16:33
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Remove highlighted number
The hardest part is figuring out what function to use
ingh
Sent: 29 November 2012 14:56
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Remove highlighted number
Hi,
You can also use
=REPLACE(A1,3,2,"")
On Thu, Nov 29, 2012 at 8:17 PM, Manjunath Narayanappa
wrote:
Dear Experts.
In a spreadsheet there are more than
: $$Excel-Macros$$ Remove highlighted number
Hi,
You can also use
=REPLACE(A1,3,2,"")
On Thu, Nov 29, 2012 at 8:17 PM, Manjunath Narayanappa
mailto:manjunath.narayana...@aon.co.uk>> wrote:
Dear Experts.
In a spreadsheet there are more than 80 policy for example below. I want to
Hi,
You can also use
=REPLACE(A1,3,2,"")
On Thu, Nov 29, 2012 at 8:17 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> Dear Experts.
>
>
>
>
>
> In a spreadsheet there are more than 80 policy for example below. I want
> to remove 3rd & 4th for below entries
>
>
>
> Examples
LEFT(A1,2)&RIGHT(A1,LEN(A1)-4)
On Thu, Nov 29, 2012 at 8:17 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> PH1106220
>
> AK0721911
>
> AG0600641
>
> AK0915631
>
> AK1015631
>
> AK1015631
>
> AK0915631
>
> AK0721911
>
> AK0915631
>
--
*Regards*
* *
*Ashish Koul*
*Vis
