Data validation lists

[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

 

[jpdphd]

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

The best delimiter to use would be CHAR(13) which is a carriage
return.
If you have names in col G
streets in col H
city, state zip in col I

then put this into col J
=G2&CHAR(13)&H2&CHAR(13)&I2

and make col J the source of the validation list.
When the popup list is seen, the column items are in one line
separated by spaces. But, when line is chosen, it will appear as
separate lines. You will have to format the cell for "wrap text".

Hope this helps.
jpdphd