Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
In a new tab, type A1 in cell A1, Type A2 in Cell A2 Use fill series to complete the values in column A Type A1 in cell B1 Use this formula in cell B2 =B1&","&A2 Copy the formul...
Answer
#5: Post edited
by
James Jenkins
·
2020-08-14T15:55:44Z (over 3 years ago)
* In a new tab, type A1 in cell A1,* Type A2 in Cell A2- * Use fill series to complete the values in column A
* Type A1 in cell B1* Use this formula in cell B2- `=B1&","&A2`
- * Copy the formula down.
Copy and paste values to harvest the string of values you created.- A1 A1
- A2 A1,A2
- A3 A1,A2,A3
- A4 A1,A2,A3,A4
- A5 A1,A2,A3,A4,A5
- A6 A1,A2,A3,A4,A5,A6
- A7 A1,A2,A3,A4,A5,A6,A7
- A8 A1,A2,A3,A4,A5,A6,A7,A8
- A9 A1,A2,A3,A4,A5,A6,A7,A8,A9
- A10 A1,A2,A3,A4,A5,A6,A7,A8,A9,A10
- * In a new tab, type `A1` in cell `A1`,
- * Type `A2` in Cell `A2`
- * Use fill series to complete the values in column A
- * Type `A1` in cell `B1`
- * Use this formula in cell `B2`
- `=B1&","&A2`
- * Copy the formula down.
- Copy and Paste Special, Values to harvest the string of values you created.
- A1 A1
- A2 A1,A2
- A3 A1,A2,A3
- A4 A1,A2,A3,A4
- A5 A1,A2,A3,A4,A5
- A6 A1,A2,A3,A4,A5,A6
- A7 A1,A2,A3,A4,A5,A6,A7
- A8 A1,A2,A3,A4,A5,A6,A7,A8
- A9 A1,A2,A3,A4,A5,A6,A7,A8,A9
- A10 A1,A2,A3,A4,A5,A6,A7,A8,A9,A10
#4: Post edited
by
pnuts
·
2020-08-14T15:53:22Z (over 3 years ago)
- * In a new tab, type A1 in cell A1,
- * Type A2 in Cell A2
- * Use fill series to complete the values in column A
- * Type A1 in cell B1
* Use this forumal in cell B2- `=B1&","&A2`
- * Copy the formula down.
- Copy and paste values to harvest the string of values you created.
- A1 A1
- A2 A1,A2
- A3 A1,A2,A3
- A4 A1,A2,A3,A4
- A5 A1,A2,A3,A4,A5
- A6 A1,A2,A3,A4,A5,A6
- A7 A1,A2,A3,A4,A5,A6,A7
- A8 A1,A2,A3,A4,A5,A6,A7,A8
- A9 A1,A2,A3,A4,A5,A6,A7,A8,A9
- A10 A1,A2,A3,A4,A5,A6,A7,A8,A9,A10
- * In a new tab, type A1 in cell A1,
- * Type A2 in Cell A2
- * Use fill series to complete the values in column A
- * Type A1 in cell B1
- * Use this formula in cell B2
- `=B1&","&A2`
- * Copy the formula down.
- Copy and paste values to harvest the string of values you created.
- A1 A1
- A2 A1,A2
- A3 A1,A2,A3
- A4 A1,A2,A3,A4
- A5 A1,A2,A3,A4,A5
- A6 A1,A2,A3,A4,A5,A6
- A7 A1,A2,A3,A4,A5,A6,A7
- A8 A1,A2,A3,A4,A5,A6,A7,A8
- A9 A1,A2,A3,A4,A5,A6,A7,A8,A9
- A10 A1,A2,A3,A4,A5,A6,A7,A8,A9,A10
#3: Post edited
by
James Jenkins
·
2020-08-13T17:28:13Z (over 3 years ago)
- * In a new tab, type A1 in cell A1,
- * Type A2 in Cell A2
- * Use fill series to complete the values in column A
- * Type A1 in cell B1
- * Use this forumal in cell B2
=B1&","&A2- * Copy the formula down.
- Copy and paste values to harvest the string of values you created.
- A1 A1
- A2 A1,A2
- A3 A1,A2,A3
- A4 A1,A2,A3,A4
- A5 A1,A2,A3,A4,A5
- A6 A1,A2,A3,A4,A5,A6
- A7 A1,A2,A3,A4,A5,A6,A7
- A8 A1,A2,A3,A4,A5,A6,A7,A8
- A9 A1,A2,A3,A4,A5,A6,A7,A8,A9
- A10 A1,A2,A3,A4,A5,A6,A7,A8,A9,A10
- * In a new tab, type A1 in cell A1,
- * Type A2 in Cell A2
- * Use fill series to complete the values in column A
- * Type A1 in cell B1
- * Use this forumal in cell B2
- `=B1&","&A2`
- * Copy the formula down.
- Copy and paste values to harvest the string of values you created.
- A1 A1
- A2 A1,A2
- A3 A1,A2,A3
- A4 A1,A2,A3,A4
- A5 A1,A2,A3,A4,A5
- A6 A1,A2,A3,A4,A5,A6
- A7 A1,A2,A3,A4,A5,A6,A7
- A8 A1,A2,A3,A4,A5,A6,A7,A8
- A9 A1,A2,A3,A4,A5,A6,A7,A8,A9
- A10 A1,A2,A3,A4,A5,A6,A7,A8,A9,A10
#2: Post edited
by
James Jenkins
·
2020-08-13T17:27:31Z (over 3 years ago)
*In a new tab, type A1 in cell A1,*Type A2 in Cell A2*Use fill series to complete the values in column A*Type A1 in cell B1* Use this forumal in cell B2- =B1&","&A2
* Copy the formula down.- Copy and paste values to harvest the string of values you created.
- A1 A1
- A2 A1,A2
- A3 A1,A2,A3
- A4 A1,A2,A3,A4
- A5 A1,A2,A3,A4,A5
- A6 A1,A2,A3,A4,A5,A6
- A7 A1,A2,A3,A4,A5,A6,A7
- A8 A1,A2,A3,A4,A5,A6,A7,A8
- A9 A1,A2,A3,A4,A5,A6,A7,A8,A9
- A10 A1,A2,A3,A4,A5,A6,A7,A8,A9,A10
- * In a new tab, type A1 in cell A1,
- * Type A2 in Cell A2
- * Use fill series to complete the values in column A
- * Type A1 in cell B1
- * Use this forumal in cell B2
- =B1&","&A2
- * Copy the formula down.
- Copy and paste values to harvest the string of values you created.
- A1 A1
- A2 A1,A2
- A3 A1,A2,A3
- A4 A1,A2,A3,A4
- A5 A1,A2,A3,A4,A5
- A6 A1,A2,A3,A4,A5,A6
- A7 A1,A2,A3,A4,A5,A6,A7
- A8 A1,A2,A3,A4,A5,A6,A7,A8
- A9 A1,A2,A3,A4,A5,A6,A7,A8,A9
- A10 A1,A2,A3,A4,A5,A6,A7,A8,A9,A10
#1: Initial revision
by
James Jenkins
·
2020-08-13T17:26:35Z (over 3 years ago)
*In a new tab, type A1 in cell A1,
*Type A2 in Cell A2
*Use fill series to complete the values in column A
*Type A1 in cell B1
* Use this forumal in cell B2
=B1&","&A2
* Copy the formula down.
Copy and paste values to harvest the string of values you created.
A1 A1
A2 A1,A2
A3 A1,A2,A3
A4 A1,A2,A3,A4
A5 A1,A2,A3,A4,A5
A6 A1,A2,A3,A4,A5,A6
A7 A1,A2,A3,A4,A5,A6,A7
A8 A1,A2,A3,A4,A5,A6,A7,A8
A9 A1,A2,A3,A4,A5,A6,A7,A8,A9
A10 A1,A2,A3,A4,A5,A6,A7,A8,A9,A10