On Fri, 4 Nov 2005 10:07:33 -0600, JulianActon
wrote:


Gents, many thanks for your suggestions.

Have tried both solutions, both give #Value! when the data is not
“Employees 12345 . . . . etc”

The | is not a column border, it’s just part of the text.

Am currently trying to diagnose why am still getting #value!

As I posted in my response with regard to your data format, "If your entries
have greater variation, then post back with more data".

You are getting the VALUE error because the data is not in the format that you
posted.

It's hard for us to guess at what your various formats might be. Unless you
share that with us, coming up with a solution will be very difficult and time
consuming.

So give examples of the various formats of these entries.


--ron