Stripping unwanted data from fields

  • Thread starter Thread starter Robin
  • Start date Start date
R

Robin

Hi,

does anyone know a way to remove data of a certain type
from a field.
To explain further i'm importing numbers from a db
(access) which have a letter appended to the end e.g.
4821B.

I need to remove the 'B' (the letter at the end) so that
all i'm left with is a numeral.

Hope this is clear enough.

Robin
 
Robin said:
Hi,

does anyone know a way to remove data of a certain type
from a field.
To explain further i'm importing numbers from a db
(access) which have a letter appended to the end e.g.
4821B.

I need to remove the 'B' (the letter at the end) so that
all i'm left with is a numeral.

Hope this is clear enough.

Robin
Click to expand...

If all the 'numbers' have a single letter at the end, you could use a
formula such as
=VALUE(LEFT(A1,LEN(A1)-1))
(copied down) to extract the numeric part as a number.
Then, of course, you can copy the resulting column and paste values to
eliminate the formulas, and then delete the original data.

If your data are more variable than all having a single letter, post back
with details.
 
Thanks!

Seems to work fine. A few rows dont work but i can find
that for myself and out of over 600 20-30 can be done
manually.

You star.

Your formula correctly
 
Back
Top