REPT

傳回將指定文字重複多次的結果。

使用範本

REPT("ha",4)

REPT(A2,3)

語法

REPT(text_to_repeat, number_of_repetitions)

• 重複文字 要重複的字元或字串。

• 重複次數 - The number of times 重複文字 should appear in the value returned.

  • The maximum number of repetitions is 100. IF 重複次數 is greater than 100, REPT will only repeat the text 100 times.

附註

• REPT does not insert spaces between repetitions of 重複文字 . IFspaces are desired, a space must be appended to the end of the value of 重複文字 . The resulting return value from REPT will have at least one trailing space, which may be removed with TRIM.

另請參閱

TRIM: 移除文字開頭、結尾和重複的空格。

SUBSTITUTE: 以新文字取代字串中的現有文字。

SPLIT: 以指定字元或字串分隔文字，並將分隔後的區段放入同一列的不同儲存格。

範例