how to split cells

[Rockbear]

A1 B1
3000 Salg, innenlands avg.pl. -886355,08
3001 Salg, prov, avg.pl. 0
3002 Salg timer egene ansatte 0

A1 contains this: 3000 Salg, innenlands avg.pl.

i AM TRYING TO GET IT THIS WAY

A1 B1
3000 Salg, innenlands avg.pl.

Anyone know how to do it?

 

[Teethless mama]

Data > Text to Columns > Fixed width > Next > Remove 2nd and 3rd arrows >
Finish

 

[Richard Schollar]

Hi

If the numbers are always 4 digits long then I would suggest selecting these
cells and going Data>TextToColumns>Fixd Width>Next and place a delimiter
after the 4th digit and then click Finish.

 

[Sean Timmons]

If the numbers vary,

In B1

=Left(A1,find(" ",A1)-1)

then
in C1

=Right(A1,len(A1)-Find(" ",A1)

Copy and paste special/values, delete column A

 

[Rockbear]

Worked like a charm, a million thanks

 

[Rockbear]

Wow that worked also with the text fields, wonderfull, thanks a millon

 

[Rockbear]

thanks a millon worked just fine