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 excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
