Abstracting text

Giganews Newsgroups
Subject: Abstracting text
Posted by:  Bill Ridgeway (in…@1001solutions.co.uk)
Date: Thu, 25 May 2006

I have a column containing names which have two elements (of differing
length) separated by a space.  I am looking for formulae which will return
the two elements separately (preferably without the intervening space).


Bill Ridgeway