I have a string of text as follows:
B1-L1-A-S1-R1-C1
I need to increment different parts of the string while some may stay the same, and that new string is placed in a new cell which is then incremented and so on.
I need to do this many, many, many times.
I have a brand new workbook, no data.
Is there a formula that can accomplish this? Do I need to enter each set of data in the string in different cells and pull from there? I am relatively new to excel sheets such as this and would appreciate any advice/help.
B1-L1-A-S1-R1-C1
I need to increment different parts of the string while some may stay the same, and that new string is placed in a new cell which is then incremented and so on.
I need to do this many, many, many times.
I have a brand new workbook, no data.
Is there a formula that can accomplish this? Do I need to enter each set of data in the string in different cells and pull from there? I am relatively new to excel sheets such as this and would appreciate any advice/help.