Using Excel, I want to remove certain characters from spreadhseet

It is not so difficult using the correct functions. MID takes a part of a string starting a specified starting position for a specified number of characters. FIND finds a character in a text and returns the position. CHAR(34) is used to search for the " sign, because otherwise you would have to many "'s. LENGTH is used to find the length of the string.

=MID(B5,FIND(CHAR(34),B5)+1,LENGTH(B5)-(FIND(CHAR(34),B5)))

I thus extract the piece of text starting after the " sign for a length of the " sign to the end of the string.

You can use nested "SUBSTITUTE" function in the excel.

For example, =SUBSTITUTE(B3," ","")

this will replace the space character in cell B3 with null string.

You can use nested one for this one:

=SUBSTITUTE( SUBSTITUTE(Cell, ",", ""), "12345.","")

as the result you will have the email address between quotation marks.

In order to remove quotation marks you can use the same approach with substituting the quotation mark character.

"""" escapes a "

Therefore,

SUBSTITUTE( SUBSTITUTE(Cell, """", ""), """","")

and as the result you will have the email address.

You can also nest it all at once, but you may get lost. It's easier to do it twice and then delete the row or column you donnot want