Remove special characters from the specified string in excel

0 votes

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.

Should represent:

$hello world$. World is beautiful. $where there is will there is a way. $money makes many things$.

Thanks All

Mar 10, 2022 in Database by Edureka
• 13,690 points
1,658 views

1 answer to this question.

0 votes

To erase a specific character from a cell, use the SUBSTITUTE function in its simplest form to replace it with an empty string:

AS A REPLACEMENT (cell, char, "")

answered Mar 15, 2022 by gaurav
• 23,260 points

Related Questions In Database

0 votes
1 answer

Fetch first 5 characters of the string

There are a lot of ways to ...READ MORE

answered Oct 22, 2018 in Database by DataKing99
• 8,250 points
5,907 views
0 votes
1 answer

Prevent cell numbers from incrementing in a formula in Excel

In Excel, you can use a feature ...READ MORE

answered Mar 15, 2022 in Database by gaurav
• 23,260 points
10,773 views
0 votes
1 answer

Excel formula to remove space between words in a cell

There are three fast techniques to get ...READ MORE

answered Mar 30, 2022 in Database by gaurav
• 23,260 points
797 views
0 votes
1 answer

Generating username from first name and last name in excel

How to automatically merge first and last ...READ MORE

answered Mar 30, 2022 in Database by gaurav
• 23,260 points
5,571 views
0 votes
1 answer
0 votes
1 answer

Remove duplicates within a row

To check for duplicates, choose the cells ...READ MORE

answered Mar 15, 2022 in Database by gaurav
• 23,260 points
664 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Remove time from date field in Excel formula

Use the Find And Replace function to ...READ MORE

answered Mar 30, 2022 in Database by gaurav
• 23,260 points
940 views
0 votes
1 answer

How to sort dates from Oldest to Newest in Excel?

Drag down the column to select the ...READ MORE

answered Feb 23, 2022 in Database by gaurav
• 23,260 points
5,245 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP