Vba required to remove Ordinal suffix from the numbers

Hi Friends,
i have a task to remove the Ordinal from the Numbers from the range D3:D1000

example:
1st Ave
22nd Street
33rd Avenue
100th St

has to be changes as:
1 Ave
22 Street
33 Avenue
100 St


Thanks in Advance.

How about

Please Login or Register  to view this content.

Sir,
Thanks for looking on my post,
i tried with your code, but its removing all the valid characters from the range,
could you please check it, i have attached the Excel file.

Thanks.

That's because your data & the samples you posted originally are completely & utterly different.
Unfortunately I cannot help with your real data.

Originally Posted by Fluff13

That's because your data & the samples you posted originally are completely & utterly different.
Unfortunately I cannot help with your real data.

okay sir,

then i have try with below type of code, but i have to write it 1000 lines

HTML Code: 

Thank you so much Fluff13 Sir

Hi

You only need to write it 10 times..
..since replace "1st", "1" will replace 21st with 21, 371st will become 371
..52nd will become 52, 972nd will become 972 etc etc etc

so use..

Please Login or Register  to view this content.

zeddy

Thank you so much Bo_Ry & zzzeddy

Both of your code works Perfectly, Thank you so much for your Help!!!

Awesome Forum Member