Formula to copy 1 cell by number in another
Solved/Closed
tanz25
tanz25
- Posts
- 4
- Registration date
- Tuesday July 13, 2010
- Status
- Member
- Last seen
- July 14, 2010
tanz25
- Posts
- 4
- Registration date
- Tuesday July 13, 2010
- Status
- Member
- Last seen
- July 14, 2010
Related:
- Suppose cell c5 contains the formula =b$6+c1
- Suppose cell c5 contains the formula =b$6+c1. match each formula with its respective cell if you copied it. - Best answers
- Suppose cell c5 contains the formula - Best answers
- Suppose cell c5 contains the formula =b$6+c1. match each formula with its respective cell if you copied it. ✓ - Forum - Excel
- Run macro when cell value changes by formula ✓ - Forum - Excel
- Excel increment cell value by 1 formula ✓ - Forum - Excel
- If cell contains date then formula ✓ - Forum - Office Software
- If cell color is then formula excel - Guide
2 replies
rizvisa1
Jul 13, 2010 at 09:51 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jul 13, 2010 at 09:51 PM
Hi Tanz,
If I understand you correctly you would like cell D1 to be like this:
Hello Hello Hello Stuff Stuff Stuff Stuff Stuff Stuff hannah hannah
First you need to split your data into two columns. Go to top menu Data > Text to columns (or delimiter) and follow on screen directions.
Now use this formula in D1:
=REPT(A1 & " ",B1) & REPT(A2 & " ",B2) & REPT(A3 & " ",B3)
Is this the result you were looking for?
Best regards,
Trowa
If I understand you correctly you would like cell D1 to be like this:
Hello Hello Hello Stuff Stuff Stuff Stuff Stuff Stuff hannah hannah
First you need to split your data into two columns. Go to top menu Data > Text to columns (or delimiter) and follow on screen directions.
Now use this formula in D1:
=REPT(A1 & " ",B1) & REPT(A2 & " ",B2) & REPT(A3 & " ",B3)
Is this the result you were looking for?
Best regards,
Trowa
tanz25
Jul 13, 2010 at 02:41 PM
- Posts
- 4
- Registration date
- Tuesday July 13, 2010
- Status
- Member
- Last seen
- July 14, 2010
Jul 13, 2010 at 02:41 PM
This is very close to what i need except i need it to be in separate cells
so i need it to be
Hello
hello
hello
Stuff
Stuff
Stuff
Stuff
Stuff
Stuff
Hannah
Hannah
so i need it to be
Hello
hello
hello
Stuff
Stuff
Stuff
Stuff
Stuff
Stuff
Hannah
Hannah
Jul 13, 2010 at 10:15 PM
Jul 14, 2010 at 05:12 PM
Jul 14, 2010 at 05:34 PM