removing characters

[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

 

[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

 

[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!

 

[Peo Sjoblom]

You might also want to look at this if this is your problem

http://support.microsoft.com/default.aspx?scid=kb;[LN];214285

all on one line

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom