Removing text from cells
The below formula will extract contents from the 1st numeric onwards..Try
and post back whether this will work for all your data?
spray 2.5oz -------------will return 2.5oz
body spray 2.5oz -------will return 2.5oz
=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"01234 56789")),LEN(A1))
If this post helps click Yes
---------------
Jacob Skaria
"don wonnell" wrote:
Have Excel 2002, want to remove text from cells and leave the numerical data
in those cells intact. Don't see a method for this in worksheet functions
listed by category / text & data.
--
labor market analyst, NW Ohio
|