Page 1 of 1

Delete First and Last Char of a String

Posted: Mon Jan 31, 2005 5:32 pm
by KPL
I just bought Advanced Find & Replace
In Excel I have variable length strings preceeded and followed by comas as follows:
,6,7,8,3,21,
,78,54,28,
In every case, I would like to delete the comas "," at the beginning and end of the strings. How can I do this?