CODEWITHSUNDEEP
excel
user3461278
user3461278

Reputation: 3

Remove all nonnumeric characters from a cell in Excel (no VBA)

I'm trying to have one cell that has date in the format 12-AUG-1984 and another cell in another sheet of the same workbook convert to ONLY two things (please show me how to do both using Excel):

1) Remove the two hypens 2) convert the date to all numbers where even Aug (August) becomes 08 so it'll be 12081984

I tried to find other questions that answer this but they seem to be either in VBA or some other code. I'm very much a novice so VBA is a bit of a problem.

Sorry and thank you.

Upvotes: 0

Views: 729

Answers (1)

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35853

Try this one for Remove the two hypens:

=TEXT(A1,"ddmmmyyyy")

and this one for convert the date to all numbers where even Aug (August) becomes 08:

=TEXT(A1,"ddmmyyyy")

Upvotes: 2

Related Questions