Getting rid of Tick Marks

[gluemthkid]

Ok - here's the deal. Some sent me a large spreadsheet with random rows throughout the spreadsheet highlighted in diffierent colors. I have a module that will sort the spread sheet by Color - however it doesn't work on this spreadsheet because - for whatever reason - every cell starts with a tick mark.

I tried to do a replace all - and excel just told me I was crazy.

I even tried going through and manually removing the tick marks - still no luck.

If I export the sheet in to txt and then re-import it I will loose all the highlights...

Any suggestions.

 

[indiantrix]

Persistence here may just win the day! Try this: add 0 to all the cells involved.
First, select any empty cell and perform an EDIT | COPY. Then select all the cells
with the annoyance and choose EDIT | PASTE SPECIAL | ADD and click OK.
Not certain if this will do it, but willing to keep offering possible solutions if it can
help you. Larry.

 

[CountryFam]

THANK YOU!!! I have been trying to figure this out myself... The VB Method worked slick!!

 

[kviola]

I use the same process as Larry stated above only by multiplying by 1 instead of adding 0. It works for getting rid of leading zeros, hyperlinks, and unsearchable characters, like tick marks. Simply put a 1 in an unused cell, click it and copy the cell, select all cells of interest, paste special and choose multiply.

 

[tswa]

To get rid of the tick marks, copy then paste-values. This worked for me.

 

[StephanieM]

Try this: Select the column of tick-marked cells
Then Data | Text to Columns | Delimited | Next | Next | Choose General option.
Hope this helps! Larry

Indiantrix, I think I love you. Seriously large file with this issue.

Thanks.
StephanieM

 

[StephanieM]

Ok - here's the deal. Some sent me a large spreadsheet with random rows throughout the spreadsheet highlighted in diffierent colors. I have a module that will sort the spread sheet by Color - however it doesn't work on this spreadsheet because - for whatever reason - every cell starts with a tick mark.

I tried to do a replace all - and excel just told me I was crazy.

I even tried going through and manually removing the tick marks - still no luck.

If I export the sheet in to txt and then re-import it I will loose all the highlights...

Any suggestions.

I didn't know Excel could say that someone was crazy.