User Profile
QuantumMaximus
Copper Contributor
Joined Nov 05, 2023
User Widgets
Recent Discussions
I need Excel Help
In my sheet, cell B2 has the following string "ABCDEF-A012340WABCD-0101" and cell C2 has a value of 3. I need a formula that outputs 3 separate lines in cell D2. Each line should be separated by 'alt+enter' and the strings value should be incremented so that the end result is. ABCDEF-A012340WABCD-0101 ABCDEF-A012340WABCD-0102 ABCDEF-A012340WABCD-0103 Does anyone know what formula I can use to accomplish this? I have over 500 lines where I need to do this and for every line the value in c2 will be different. Basically I am seeking a formula that looks at the name and quantity and outputs what is in the result in the increment columns as shown below. Any help would greatly be appreciated. Base Name Qty Increment 1234 ABCDEF-A012340WABCD-0101 3 ABCDEF-A012340WABCD-0101 ABCDEF-A012340WABCD-0102 ABCDEF-A012340WABCD-0103Solved1.7KViews0likes4Comments
Recent Blog Articles
No content to show