Visual Basic Forum for Visual Basic Programmers VB

[Enda80]

Hello, I feel a little embarrassed. An acquaitance
asked me a question. Namely, he works for a REIT
company and he has to put together a project where
they must retrieve various documents from the
archives. By convention, the documents are stored
according to the name of the street the property is
on, not by the street address number, and prefixes
such as "North" or "South" are ignored in ordering the
files.

He has an excel file with a list of all the
properties, but sadly, the properties are input with
the street number and directional prefixes (e.g.
"East" for "East Clinton" street) in the cell. So
sorting them in the Excel file would not at all
correspond with the order they would appear while
searching in the archives for them.

Is there a way to remove digits and digits only? I am
aware of Len and
[link] microsoft. com/en-us/ excel/HA01154901 1033.aspx? pid=CL1005705510 33