=SUBSTITUTE(A5,CHAR(10),"、")

=REGEXREPLACE(A6,"(\d+)円","$1 yen")

=TRIM(A7)

=REGEXREPLACE(A7,"[ 　]+","")

=SUBSTITUTE(A8,"株式会社","")

=SUBSTITUTE(B5,"、",CHAR(10))
