Hi Alvin,

If you want to do this with code:
Look at the Split() function in online VBA help for examples, using the
space character as the delimeter.

If you want to do this with inplace formulas:
Assuming text is in A1:
TargetCell1 formula is =LEFT(A1,4).
TargetCell2 formula is =MID((A1,FIND(" ",A1)+1,4)
TargetCell3 formula is =RIGHT(A1,4)


Regards,
Garry

"alvin Kuiper" wrote:

Hi

I have this in a cell "Text 4numbers Text "
I want to take the first text into a cell
then i want to take the 4 numbers into another cell
and then i want to take the last text into another cell

MAybe i can split by the numbers?
like take alle text before the numbers
then take the numbers and then take alle the text
after the numbers???

Hope someone can help.

Besr regards
Alvin