how to split cells
 

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?

--
Just a regular user

how to split cells
 

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


"Rockbear" wrote:

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?

--
Just a regular user

how to split cells
 

Hi

If the numbers are always 4 digits long then I would suggest selecting these
cells and going DataTextToColumnsFixd WidthNext and place a delimiter
after the 4th digit and then click Finish.

--
Richard Schollar

Microsoft MVP - Excel


"Rockbear" wrote in message
...
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?

--
Just a regular user

how to split cells
 

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

"Teethless mama" wrote:

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


"Rockbear" wrote:

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?

--
Just a regular user

how to split cells
 

Worked like a charm, a million thanks
--
Just a regular user


Teethless mama skrev:

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


"Rockbear" wrote:

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?

--
Just a regular user

how to split cells
 

Wow that worked also with the text fields, wonderfull, thanks a millon
--
Just a regular user


Sean Timmons skrev:

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

"Teethless mama" wrote:

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


"Rockbear" wrote:

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?

--
Just a regular user

how to split cells
 

thanks a millon :) worked just fine
--
Just a regular user


Richard Schollar skrev:

Hi

If the numbers are always 4 digits long then I would suggest selecting these
cells and going DataTextToColumnsFixd WidthNext and place a delimiter
after the 4th digit and then click Finish.

--
Richard Schollar

Microsoft MVP - Excel


"Rockbear" wrote in message
...
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?

--
Just a regular user