split cell content

  • Thread starter Thread starter portroe
  • Start date Start date
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
 
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
 
Back
Top