Not familar with this type of code. Is it VB code?
If so, how do I use it?

TIA
Bob

On Thu, 24 Mar 2005 14:45:14 -0600, "Chip Pearson"
wrote:

Bob,

Is the data really delimited by a | character? If so, use the
following code:


Dim S As String
Dim F As String
Dim Pos As Integer
S = Range("A1").Text
Pos = Inkster(1, S, "|")
F = Left(S, Pos - 1)
Debug.Print F