I am trying to get Excel to auto populate a cell based on the data in another. I have tried a few formulas but keep getting errors and know it's not this complicated.
I need a formula that will change the data in column 1 to look like column 2. I'm simply trying to drop off the letter in column 1 to do some data analysis.
<tbody>
</tbody>
I need a formula that will change the data in column 1 to look like column 2. I'm simply trying to drop off the letter in column 1 to do some data analysis.
A2 | 2 |
B1 | 1 |
A3 | 3 |
B5 | 5 |
B2 | 2 |
<tbody>
</tbody>