Hi,
I have a problem below pls help asap..
in a colum A there are some text and numeric values, so i want in column B to display only the list of text excluding the numeric values,
Thanks
Hi,
I have a problem below pls help asap..
in a colum A there are some text and numeric values, so i want in column B to display only the list of text excluding the numeric values,
Thanks
See if this works for you:
http://vbaexpress.com/forum/showthre...=XtractNumbers
"Intellectual passion occurs at the intersection of fact and implication."
SGB
Please use meaningful titles for your questions.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'