Forum Discussion

Copper Contributor

Aug 19, 2019

Copy cells from column A to column C, x times (with x as variable in Column B). Easy formula?

Is there an easy formula to copy cells from column A to column C, x times (with x as variable in Column B). Easy formula? 8.B 3 8.B 4.C 1 8.B 1.A 2 8.B 4.C ...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Aug 19, 2019

EmilyAnn_55-55

Please check an answer here https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-repeat-text-n-times-in-excel-2010/4059fc11-f819-43b5-91c0-41435e3a4bfe?auth=1

EmilyAnn_55-55
Copper Contributor
Aug 19, 2019
That is AWESOME! Thank you Sergei Baklan (MVP)! An answer within an hour!
- SergeiBaklan
  Diamond Contributor
  Aug 19, 2019
  EmilyAnn_55-55 , you are welcome