View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Splitting up text between two fields

Hi
is this prefix somehow separated from the rest of the text (e.g. with a
space)?

--
Regards
Frank Kabel
Frankfurt, Germany

"Brian" schrieb im Newsbeitrag
...
I have a list of addresses and need to move the suffix
(DR, ST, AVE, CIR, RD) to the cell to the right. Is there
a macro I could program to do this? I have alot of them
and don't really want to do this by hand one at a time.

Thanks.