Hi -
I thought I saw the solution here, but I can't seem to find it again so I'm
submitting my own version. Please apologies for any duplication. I've been
looking for what feels like eons. Here is the problem.

I've imported a text file into Excel. All of it is fine except for the
format of the year. There is no consistency and very rarely are they just 4
numbers together. They look like:

c1982.
[1973, c1966]
[1942]
c1995-
[1964?, c1962]
1969]
1973 [c1972]

As you can see it's all over the place. Is it possible to write a formula or
macro that can delete everything but the numbers in this column? It's in
column D. Any help or advice - even if you just want to direct me to the
question that was already submitted - would be really appreciated.
Thanks,
Celina