Hi. I have a field in Excel 2007 that I need to delete text in the middle. Each field has "," (quote comma quote) in it and I need to delete the character that is 4 spaces to the left of it and 4 spaces to the right of it. Is there a way to do it, almost like the LEFT and RIGHT commands remove from the front and end of a field? Somehow where it can locate that text (",") and work right and left from it? It is NOT a uniform number of spaces in each field to reach the text (",") (like always 28 characters from the beginning). Thanks.
Bookmarks