thanks Jaysheel \ Waseem \ MARIES \ Rajan
regards,
Aamir Shahzad
On Wed, Apr 4, 2012 at 1:22 PM, Rajan_Verma wrote:
> Hi
>
> Please find the attached sheet’
>
> =IF(ISNUMBER(INT(RIGHT(C2,6))),INT(RIGHT(C2,6)),"")
>
>
>
>
>
> Rajan
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-
Hi
Please find the attached sheet'
=IF(ISNUMBER(INT(RIGHT(C2,6))),INT(RIGHT(C2,6)),"")
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aamir Shahzad
Sent: Apr/Wed/2012 01:17
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Extrac
Hi,
Try below array formula,
=MAX(IFERROR(RIGHT(C2,{1,2,3,4,5,6,7,8,9,10})*1,""))
Apply with Ctrl + Shift + Enter.
Regards,
MARIES
On Wed, Apr 4, 2012 at 10:21 AM, Waseem Saifi wrote:
> please check attached file.
>
>
> On Wed, Apr 4, 2012 at 1:17 AM, Aamir Shahzad wrote:
>
>> Dear Group,
>
please check attached file.
On Wed, Apr 4, 2012 at 1:17 AM, Aamir Shahzad wrote:
> Dear Group,
>
> How to extract 6 digit numbers from right if its number & convert this to
> numbers by formula. See the attached file.
>
> Regards,
>
> Aamir Shahzad
>
> --
> FORUM RULES (986+ members already BAN
Hi Aaamir,
Please find the attached data. please check and let me know is this your
requirement.
Regards,
Jaysheel Bhasme
On Wed, Apr 4, 2012 at 1:17 AM, Aamir Shahzad wrote:
> Dear Group,
>
> How to extract 6 digit numbers from right if its number & convert this to
> numbers by formula. See th
