How do I turn single line data into rows?

[shaun collier]

Hi guys,
Thanks to all that pointed me to data validation...works great. Now I can
use data validation for pull down menus....but I want to put addresses of
customers into a list...so I can use them to invoice quicker...this is easy
if I put the addresses into one cell and use the list. Is it possible to put
addresses into a list in the normal way i.e., as you would write it on an
envelope? Or is there a way so the displayed line is put to rows eg some
sort of delimiter


For example I want to display

123,Abc, etc

As

123
Abc
Etc

Regards

Shaun

 

[Pete_UK]

If the commas are used only to separate the fields (i.e. you do not
have 123, High Street), then you could use Find & Replace (CTRL-H) to
Find a <comma> and <space> and Replace with character 10 (hold down
Alt and type 010 on the numeric keypad). This will give a line-feed
within the cell - you may have to adjust the row height or set the
format of the cell to Wrap to see it properly.

Hope this helps.

Pete