not that I know of... I'd try exporting to CSV format (or save the workbook
as CSV), open it in word, do a search and replace on the Cr and save - open
in excel and text to column it. It's possible that excel can do a search and
replace and you can save a step, but I know it's quite easy in word.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"David Tong" wrote in message
...
Diane,

Thanks for the great tip. The answer is now in sight :-]

The bad news is I may have to modify all the records in Contacts so that I
have a suitable delimiter. During previous experiments I'd entered most
of the addresses into the Outlook records by pressed Enter after the house
number. If I'd used a space or a comma I'd have been alright because Step
2 of the 'convert text to columns wizard' offers these as recognisable
delimiters - but carriage return seems not to be an option.

Do you know if it's possible to indicate CR as a delimiter? There's a box
marked 'other' but it seems to accept only a single conventional
character.

--
David Tong

[Please replace 'invalid' with 'com' to reply].
"Diane Poremsky [MVP]" wrote in message
...
text to columns in excel?

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"David Tong" wrote in message
...
Our local residents association has each subscriber listed as a separate
contact in Outlook 2k. We want to print labels for a mailing by
volunteers
and it would be a big help to pre-sort the envelopes by street name
first.
Problem is I can't see how to do it.

I tried exporting the contacts as a 'Windows csv' file and opened it in
Excel 2k hoping to sort on street name. But, although town and postcode
appear correctly in the fields 'Business City' and 'Business Postcode',
all
of the rest, say '1 Acacia Gardens, Suburbia', goes into 'Business
Street'
with the two other fields 'Business Street 2' and 'Business Street 3'
empty.

Can anyone advise how we can get '1' to go into 'Business Street',
'Acacia
Gardens' into 'Business Street 2' and 'Suburbia' into 'Business Street
3'?

--
David Tong
[Please replace 'invalid' with 'com' to reply].