removing characters

N

noobie6675

Hi,

I have an xls sheet that i have outputted from a Access database.

I find that one field that i need to work with has been given a "`" i
front of it... ie instead of 3... it will have a `3

now i need to do various mathematical equations on these fields and i
wont let me do it while the ` is present. As it is a extremely larg
spreadsheet 40 thousand + i was wondering if there is a quick way t
remove this character? ie get rid of first character?

cheer
 
E

Ed Ferrero

Highlight the whole column,
use menu item Data-Text to Columns,
click Next, Next, Finish.

The defaults for text to columns convert text data to numeric.
To convert numeric to text, choose the Text option in step 3 of the wizard.

Ed Ferrero
 
D

Domenic

Hi,

You can try using the Find/Replace option.

Select your range
Edit > Replace
Find What: `
Replace with: leave blank
Replace All

Or, assuming that you have your data in column A, you can put this
formula in another column and copy it down as far as you need to:

=--RIGHT(A1,LEN(A1)-1)

Then, select the new column, Copy > Paste Special > Values, and delete
the old column.

Hope this helps!
 
Top