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.
[TABLE="width: 100"]
<tbody>[TR]
[TD]A2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]B1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]B5[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]B2[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

 

[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" ?