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 » Mon Jan 31, 2005 5:32 pm

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

Who is online

Users browsing this forum: No registered users and 1 guest