'tis very unfortunate the OP is incapable of reading or following any of the forums rules and/or has no respect for those rules nor the time of the very people from which they seek assistance.

Should have a read of this for some kind of understanding.

So no one here wastes their time.

https://www.msofficeforums.com/excel...t-strings.html
http://www.excelguru.ca/forums/showt...xtract-strings
http://www.mrexcel.com/forum/excel-q...t-strings.html
http://chandoo.org/forum/threads/vba...-string.29464/