not the nicest solution:
string test = "The Value 'sd' is not valid value";
string[] parts = test.Split('\'');
if (parts.Length > 2)
{
parts[1] = "'" + parts[1] + "'";
MessageBox.Show("Part1: " + parts[0] + " Part2: " + parts[1] + " Part3: " + parts[2]);
}