Getting rid of arrows in cells

[blackystrat]

This is my first post at MrExcel.com

I have a spreadsheet in Excel 2007 containing hundreds of thousands of data. Several cells in the sheet have a right facing arrow at the beginning of certain cells and it seems that I cannot even copy that arrow to replace it with nothing

It looks like this

please advise me on how I can batch remove these arrows from the sheet

Many thanks

 

[Snakehips]

blackystrat,

Welcome to MrExcel.

Is it possible that the arrow is e.g. 'g' of the Wingdings3 character set?

Can you interrogate a sample cell similar to below?

Then a possibility for replacement could be to replace first character of string, if e.g. 'g' with "" as it is unlikely that any wanted text will start with e.g. lower case g.

In A2 on the actual sheet it shows an arrow as per your image >> Arrowsome stuff but does not render here as such.

Excel 2007
	A	B	C	D
1	Text	Arrow character	Char code	Cleaned up
2	gsome stuff	g	103	some stuff
3	gsome stuff			some stuff
4	Gsome stuff			Gsome stuff
Input

Cell Formulas
Range	Formula
B2	=LEFT(A2,1)
C2	=CODE(B2)
D2	=IF(CODE(LEFT(A2,1))=103,REPLACE(A2,1,1,""),A2)

Hope that helps.

 

[blackystrat]

Sorry for the delay in responding but your solution helped a lot

Thanks