Removing letters in a cell

[btnhtillidie]

I have searched and didnt quite find an answer.

What i am trying to do is remove two letters in a long list of cells.

I.e UN1268 to just 1268
i.e UN0268 to just 0268

the list is long! A2:A2205

I dont think there should be a Code written for this. I dont want to go through every cell and delete UN.

Maybe an If statment would work?

Any ideas?

[kellyfspringer]

=RIGHT(A2,LEN(A2)-2)
If they are all UN then 4 digits, you can shorten that formula to
=RIGHT(A2,4)

[btnhtillidie]

=RIGHT(A2,LEN(A2)-2)
If they are all UN then 4 digits, you can shorten that formula to
=RIGHT(A2,4)

Where would you put that to reference all 2250 cells? yes they are all UN followed by 4 digits.

[teylyn]

Select the column. Hit Ctrl-H to open the Find and replace dialog. Enter

Find what: UN
Replace with: leave empty

Click Replace All.

[kellyfspringer]

I'm sorry...
I would put the formula =RIGHT(A2,4) in cell B2, then copy it down.

to copy down:
If you move your mouse over the bottom right corner of the cell that you want to copy, you can then click and drag down to cell B2205, and the cells will automatically reference the appropriate row in column A.

[btnhtillidie]

Select the column. Hit Ctrl-H to open the Find and replace dialog. Enter

Find what: UN
Replace with: leave empty

Click Replace All.

Just like butter.

Thanks.