- The numbers might have a negative sign proceeding the number itself
or a decimal or both.

Is "or none of them" a possible case?

Stefi


€žqcan€� ezt Ã*rta:

Hi,

I've tried all kinds of things, but this problem is beyond me...
Ideally I need a UDF function or a small macro to be created.

The facts a....

- Every cell in a particular column(s) has multiple characters
(string) at the begining with a numbers(s) at the end.
- The characters could possibly have spaces.
- The numbers might have a negative sign proceeding the number itself
or a decimal or both.

Problem is:

I need this column to be split into two columns with one containing
the characters and the other containing the number.

Example:

CELL A1 Contains: ABSHHF KJGG -1524.001

The function would put ABSHHF KJGG into cell A2 and -1524.001 into
cell A3.

That's it.

Thanks,