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