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).

Thanks.

Bill Ridgeway

Hi

Make a copy of your sheet first and then go to Data / Text to columns and
follow the instructions. Use delimited and have <space as delimiter.

Andy.

"Bill Ridgeway" wrote in message
...
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).

Thanks.

Bill Ridgeway

Thanks Andy. It's much easier than I thought it would be!

Bill Ridgeway

<Andy wrote in message ...
Hi

Make a copy of your sheet first and then go to Data / Text to columns and
follow the instructions. Use delimited and have <space as delimiter.

Andy.

"Bill Ridgeway" wrote in message
...
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).

Thanks.

Bill Ridgeway

Thanks for the feedback - glad you're sorted!

Andy.

"Bill Ridgeway" wrote in message
...
Thanks Andy. It's much easier than I thought it would be!

Bill Ridgeway

<Andy wrote in message ...
Hi

Make a copy of your sheet first and then go to Data / Text to columns and
follow the instructions. Use delimited and have <space as delimiter.

Andy.

"Bill Ridgeway" wrote in message
...
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).

Thanks.

Bill Ridgeway