Thread
:
Finding a string of 7 numbers in cell contents
View Single Post
#
3
Posted to microsoft.public.excel.programming
Bernd P
external usenet poster
Posts: 806
Finding a string of 7 numbers in cell contents
=regexpreplace(" "&A1&" ","^.* (\d{7}) .*$","$1")
The function regexpreplace you will find he
http://www.sulprobil.com/html/regexp.html
Regards,
Bernd
Reply With Quote
Bernd P
View Public Profile
Find all posts by Bernd P