splitting adress and zip-code

[chrchr]

Have home adress and areacode in one collumn and wants to seperate them.
Was able to get the home adress fixed but still can`t figure out how to have only the areacode and name left in another. The information is seperatet in the original sheet with a box shapet figure.

eg. Wild Bill Creek 42(box shapet symbol)4222 OAKLAND

 

[Frank Kabel]

Hi
not sure which character code this is but try
=TRIM(LEFT(A1,FIND(CHAR(13),A1)-1))
and
TRIM(MID(A1,FIND(CHAR(13),A1)+1,255))

you may have to replace
CHAR(13)
with
CHAR(10)

-----Original Message-----
Have home adress and areacode in one collumn and wants to seperate them.
Was able to get the home adress fixed but still can`t

figure out how to have only the areacode and name left in
another. The information is seperatet in the original
sheet with a box shapet figure.

 

[filky]

It sounds as if you have imported the addresses from another system an
the square symbol is a carriage return

Do you still have access to the source data? If so I think the easies
solution is to import the file again making sure you select the correc
delimiter