splitting adress and zip-code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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.
 
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
 
Back
Top