Hi Kashan, You can use following formula in column B and C respectively
=SUBSTITUTE(A1,C1,"")
=IF(VALUE(LEFT(MID(A1,SEARCH("ltr",A1)-1,50)))=0,MID(A1,SEARCH("ltr",A1)-2,50),MID(A1,SEARCH("ltr",A1)-1,50))
If you could provide some large set of data, that would have been
great to develop the full proof solution. As of now, spreadsheet is
attached to handle current situation :)
Best Regards,
DILIPandey
On 6/26/11, Kashan Abbas <[email protected]> wrote:
>
> Hi guys ,
>
> Is there any formula that can extract particullar values or text from cell
> .I want to extract the values not on the basis of position of the character
> becuase it can be easily done through left or right function .My creteria is
> value base let say i want to extract values from below illustrated dummy
> collumn .In this example my target is to separte the product name and
> packing size in next collumns as :
>
> Result want to be produced
> Column b collumn c
> deo3000 4lt
> deo3000 10ltr
>
>
> Availiable data
> Collumn A
> deo30004ltr
> deo300010ltr
>
>
>
> --
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to [email protected]
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Thanks & Regards,
DILIP KUMAR PANDEY, mvp
MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
[email protected]
[email protected]
New Delhi - 62, India
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
extracting text - By DILIPandey.xls
Description: MS-Excel spreadsheet
