Google Product Forums

Re: How do i create an array of two combined texts?????


NancyH1983 2012/07/01 18:14
グループへの投稿: Google Docs

カテゴリ: Sheets : Ask a "how-to" question : Desktop (specify browser/OS) :

Try:

=IF(ISTEXT(A2),CONCATENATE(A2," ",B2)," ")

Then just drag it down through the column.