ANDY,
Could you please explain the use of "^^" in the formula.
Thanks & Regards,
C.G.Kumar
On Wed, Sep 1, 2010 at 5:53 PM, Aindril De wrote:
> Hi Kalyan,
>
> You can use the following formula in the cell B2 and then copy it down
>
> =LEFT(A2,LEN(A2)-(LEN(A2)-FIND("^^",SUBSTITUTE(A2," ","^^
Put *ARRAY FORMULA*
=LEFT(A2,MAX((MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)="
")*(ROW(INDIRECT("1:"&LEN(A2)-1)
into cell B2;
copy B2 and paste to B3:Bn
On Wed, Sep 1, 2010 at 5:11 PM, Kal xcel wrote:
> Dear Experts,
> I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits
Inst
alternative to solving Aindril and if the code is not always located at the
end
try the UDF:
Function re_alpha_numeric(ByVal s As String, _
Optional bGlobal As Boolean) As String
Dim re As Object
Set re = CreateObject("vbscript.regexp")
re.Global = bGlobal
re.Pattern = "[a-zA-Z]*\d+[a-zA-Z]+|[
Try this formula.
Regards,
Solomon
On Wed, Sep 1, 2010 at 2:11 PM, Kal xcel wrote:
> Dear Experts,
>
> I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits
> Instant Fairness Fruit Bleach 14gm), all strings are not equal. I want to
> extract only product name (like: Skin Fr
Hi Kalyan,
You can use the following formula in the cell B2 and then copy it down
=LEFT(A2,LEN(A2)-(LEN(A2)-FIND("^^",SUBSTITUTE(A2," ","^^",LEN(A2)
-LEN(SUBSTITUTE(A2," ",""))
For more info on the above please check:
http://www.eggheadcafe.com/software/aspnet/28074391/need-to-find-first---f
Dear Experts,
I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits
Instant Fairness Fruit Bleach 14gm), all strings are not equal. I want to
extract only product name (like: Skin Fruits Instant Fairness Fruit Bleach)
from that string.
File is attached.
Thanks in advance
Kal
