Changing cell information

[Fyrdawg]

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.

A2	2
B1	1
A3	3
B5	5
B2	2

<tbody>
</tbody>

 

[Marcílio_Lobão]

Fyrdawg, Good afternoon.

Suppose:

.......A........B.........
1.....A2.......=FORMULA

FORMULA --> =--MID(A1,2,100)

Is that what you want?
I hope helps.

 

[Fyrdawg]

Thank you for the info.. That formula doesn't seem to work.. I am simply trying to convert an A1/B1 to a 1, A2/B2 to a 2, etc up to A5/B5. If tried a few IF formula's but kept getting an error.

 

[Marcílio_Lobão]

The content of cell A1 is the text "A2" ?