Google spreadsheet – function to split comma separated string to few lines

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.

Leave a Reply

Your email address will not be published. Required fields are marked *