Parse Horsename

[Claus Busch]

Hi,

Am Wed, 10 Jul 2013 21:28:42 +0100 schrieb Saxman:

Maybe you could elaborate for me?

have a look for array formulas in Excel Help

To find out the issue of a formula you can select the cell with the
formula and then use Formulas => Formula Auditing => Evaluate Formula


Regards
Claus B.

 

[Saxman]

Saxman schreef in

In OpenOffice or LibreOffice, select the cells with the horsenames,
then Edit, Find & Replace,
Search for: ^(.*) (.*)$
Replace with: $1
Under More Options, check Current selection only, Regular expressions.
Then press Replace All.

Thank you.

 

[Saxman]

Hi,

Am Wed, 10 Jul 2013 21:28:42 +0100 schrieb Saxman:


have a look for array formulas in Excel Help

To find out the issue of a formula you can select the cell with the
formula and then use Formulas => Formula Auditing => Evaluate Formula

I see it now, thanks!