I am trying to remove a character from a string in excel. How can I remove the first and last character from the specified string? In excel sheet I have data in every column. Some of the test starting and ending with $$ characters, I need to remove only first character ($) and last character ($) from the string.
Example: Cell 1:
$$hello world$$. World is beautiful. $$where there is will there is a way.$$ money makes many things.
$hello world$. World is beautiful. $where there is will there is a way. $money makes many things$.