How do I turn single line data into rows?

  • Thread starter Thread starter shaun collier
  • Start date Start date
S

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
 
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
 
Back
Top