If you use Data/Text to Columns, with the delimiter as "&". That will give you
"Jones John " in column 1 and " Sharon" in column 2
But that leaves you leading and trailing spaces. If you first use Search and
Replace to replace " & " with "&", then Text to Columns, that will take care
of that issue
On Sat, 19 Feb 2005 12:11:01 -0800, "jv" wrote:
John would stay in the first column
"Myrna Larson" wrote:
And what has happened to "John"? Eliminated?
On Fri, 18 Feb 2005 10:37:12 -0800, "jv"
wrote:
I have a Column that is currently set up as follows:
jones john & sharon
I want to divide the column and make two colums like:
Column one = Jones
Column Two= & Sharon
|