hi
I am trying to extract a numeric value from a column of text that does
not always have any relevant data. Typical column entries are like
this:
Employees: 46 | Employee Growth: -4.17%
Employees: 3336 | Employee Growth: -5.66%
Employees: 1700 | Employee Growth: %
but in this mixed bag of data there are many odd entries of free text
e.g.
Two areas are using xx. Production studio's . . . . .
The data I want to extract is the number of employees, which can be
anything between a 1 and 6 digit number. I can do a basic extraction
using =MID(cellref, 12,6) to get the raw information, but this will not
always return a number. I need to remove the junk and just be left with
numbers in a new column.
If someone could give me some pointers here. Will I need to use VBA?
thanks
--
JulianActon
------------------------------------------------------------------------
JulianActon's Profile:
http://www.excelforum.com/member.php...o&userid=14921
View this thread:
http://www.excelforum.com/showthread...hreadid=482185