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
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:
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 =