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