Hello, I need to extract a text string from the end of a cell, but the string will never be consistent! I have a macro that extracts email content from Outlook and inserts it into a spreadsheet the results look like this(contents of C1):

"
11/05/2012 07:30

Communication Delays Detected

Site Last Communication
----------------------- ------------------
SiteName 11/05/2012 06:04
"

The only thing consistent is that it will always follow the dashes and it will always precede the date/time as the last characters in the cell! The SiteName can be anywhere from 3 characters to 20.

I just need a formula to extract only the SiteName into a cell by itself.

Thanks in advance!