split cell content
 

I have a lot of imported data, unfortunately the post code and city is
stored in a single cell, in the form of

12159 Berlin

Does anybody have a procedure for removing one or the other from the cells,?

thanks

Portroe

split cell content
 

Hi Portroe
if you have only German style zip codes try
Zip: =LEFT(A1,5)
City: =MID(A1,7,255)

or use 'Data - Text to columns'

Frank

portroe wrote:
I have a lot of imported data, unfortunately the post code and city
is
stored in a single cell, in the form of

12159 Berlin

Does anybody have a procedure for removing one or the other from the
cells,?

thanks

Portroe

split cell content
 

Thanks frank,

they are only German zip codes,

Portroe

Frank Kabel wrote:

Hi Portroe
if you have only German style zip codes try
Zip: =LEFT(A1,5)
City: =MID(A1,7,255)

or use 'Data - Text to columns'

Frank

portroe wrote:

I have a lot of imported data, unfortunately the post code and city

is

stored in a single cell, in the form of

12159 Berlin

Does anybody have a procedure for removing one or the other from the
cells,?

thanks

Portroe