Delete First and Last Char of a String

General discussions about Advanced Find and Replace
Post Reply
KPL

Delete First and Last Char of a String

Post 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?

Post Reply