gt; *Sender: * excel-macros@googlegroups.com
> *Date: *Thu, 14 Feb 2013 16:52:17 +0300
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Condition with concatenate function
>
> Hi,
>
> It may help.
>
> =IF(MID(A1,2,1)="M",A
xcel-macros@googlegroups.com
> *Date: *Thu, 14 Feb 2013 16:52:17 +0300
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Condition with concatenate function
>
> Hi,
>
> It may help.
>
> =IF(MID(A1,2,1)="M",A1&"
-Original Message-
From: Excel_Lover
Sender: excel-macros@googlegroups.com
Date: Thu, 14 Feb 2013 16:52:17
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Condition with concatenate function
Hi,
It may help.
=IF(MID(A1,2,1)="M",A1&"6012&qu
Hi,
It may help.
=IF(MID(A1,2,1)="M",A1&"6012",A1&"6004")
On Thu, Feb 14, 2013 at 4:33 PM, wrote:
> Hi There,
>
> I seek for experts guidance on how I can apply a formula, wherein a
> condition is, when a second letter of an alphanumeric code is "M", then
> concatenate the cell with "6012"
Hi There,
I seek for experts guidance on how I can apply a formula, wherein a condition
is, when a second letter of an alphanumeric code is "M", then concatenate the
cell with "6012" otherwise concatenate the cell with "6004".
Regards,
Pooja Sharma
Sent from BlackBerry® on Airtel
--
Are y
