*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$$ Extract desired data
>
>
>
> Dear Group,
>
>
>
> How to e
$$Excel-Macros$$ Extract desired data
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 BANNED for violation)
1) Use concise, accurate thread
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
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 BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urg
