how to split cells

  • Thread starter Thread starter Rockbear
  • Start date Start date
R

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?
 
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.
 
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
 
Back
Top