split cell content

P

portroe

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
 
F

Frank Kabel

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
 
Top