chop off extra characters in excel
=right(A1,6)
--
Gary's Student
" wrote:
I am looking for a way to remove extra charaters from a number, and
copy it to a new column. Column B is generated from column A. For
example:
A = B
11005656552 565655
11004567754 456775
13117896432 789643
Thanks for you help!
|