Use TEXTJOIN in Google Sheets to Create a Row of Keywords Separated by a Comma, no need to TRANSPOSE

Поділитися
Вставка
  • Опубліковано 17 лип 2020
  • This short 2-minute video helps explain the TEXTJOIN function in Google Sheets. The goal was to convert a list of keywords in a column to one row of words each separated by a comma.
    =TEXTJOIN(", ",TRUE,A2:A11)
    This was the example TEXTJOIN formula I used in the video to make a list of words into one row separated by a comma and a space. This works well for making a list of keywords into a single row of words.
    #textjoin #googlesheets #googlesheetstutorials
  • Навчання та стиль

КОМЕНТАРІ • 2

  • @maria.horbyk
    @maria.horbyk Рік тому

    wow what a beautiful music in tutorial! such a pleasure!