Extract Specific Text from a Cell

[ASPENCO]

I have a range of cells that I have pasted from the Web that contain an
identification number (which consists of a letter then a string of
numbers followed by a name). In the adjacent cell I would like to
extract just the name, omitting the identification number. What is the
formula for doing so? Thank you again for all of your help. Greatly
appreciate the prompt responses and accurate information that this
forum provides.

 

[Tushar Mehta]

If you install the functions in
http://www.tmehta.com/regexp/add_code.htm
then you can use =RegExpSubstitute(A15,"[a-zA-Z]{1}\d+","")
where A15 contains the original string

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Chuck]

Try using the MID function. For example
=MID(B4,4,25)
This will look in cell B4 and count the number of
characters from the left to eliminate (4), and then show
the remaining characters (25). When counting characters
don't forget to include the spaces.