Find & Replace in a single column

[Kevingardner1]

I have a spreadsheet with numbers all over the place to represent different values. Column M has numbers 1-12 to represent the months of the year. I want to change them to show the months as words.

I was going to Find & Replace them, but I can't seem to.

It seems a pretty simple thing in my head, but I can't work out how to do it.

[TMS]

Select the column before you do your Find and Replace. That should restrict the changes to that column. Then replace 12 by December, 11 by November, 10 by October and so on.

Regards

[nawas]

May be like this;

=LOOKUP(M1,$M$1:$M$12,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"})

Thanks

[martindwilson]

=TEXT(DATE(1900,m1,1),"MMM")

[Kevingardner1]

Sorry, I'm sometimes a bit of a dunce.

I have 39438 rows where column M will only have number 1 to 12 to show during which month a sale was made. I don't think selecting the column first works, I can only seem to do that by sheet or workbook (although it would made sense to have a 'selected cells only' option).

I'm pretty sure nawas or martindwilson are on the right track, but where do I put these formulas?

[nawas]

Hi Martin,

Awsome... I could learn such a simple formula can make things easy ..

Thanks

[nawas]

Hi Kevingardner1,

Could you please attach a sample sheet, showing your desired output..

Thanks

[martindwilson]

just put it in a spare column on the same row (change m1 to whatever row you start from say m2) drag down to end. once done you can copy/paste special values over the original and delete the formulas

[Kevingardner1]

Thanks Martindwilson. I've added to your reputation.

I couldn't really add a sample nawas other than to make up the other columns. It's solved now anyway. Thanks all.

[TMS]

Guess you're doing something wrong, it works for me.

See the attached image.

Regards

[Kevingardner1]

Haha, you're right!! I was totally over-complicating it!! Thanks

[TMS]

You're welcome.