How do I turn single line data into rows?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shaun collier - 21 Jun 2007 14:18 GMT

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

Reply to this Message

Pete_UK - 21 Jun 2007 14:26 GMT

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

> Hi guys,
> Thanks to all that pointed me to data validation...works great. Now I can
[quoted text clipped - 18 lines]
>
> Shaun

Reply to this Message