Face this problem to split address to few lines for printing purpose.

Example address:

No. 1 Road 2, Happy Park, 43800 Big Town, My State

to

No. 1 Road 2,
Happy Park,
43800 Big Town,
My State

Just use this function besides the cell.

=SUBSTITUTE(A1, ",", char(10))

Replace A1 with the cell number.

Another related function is SPLIT.