Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
In WORD or EXCEL, How can I convert
- Thread starter keve
- Start date
If I'm understanding you correctly, for Excel remove the Wrap Text for each column. Format, Cell, Alignment, remove the wrap text check.
In Word you may have to get creative and do a find and replace. If there are double returns ^p^p after the end of an address you problem should replace all of those first replacing those with a unique character like the bar "|". Then replace the single return ^p with a space. This will put your address in a single line. Now you need to replace the bar "|" with double ^p^p to separate each address.
I hope this help.
In Word you may have to get creative and do a find and replace. If there are double returns ^p^p after the end of an address you problem should replace all of those first replacing those with a unique character like the bar "|". Then replace the single return ^p with a space. This will put your address in a single line. Now you need to replace the bar "|" with double ^p^p to separate each address.
I hope this help.
- Status
Similar threads
- Locked
- Question
