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!
Bookmarks