Deleting partial information from all cells in a column
Ps. If your serial numbers look like:
s01234
you'll end up with
1234
(dropping the leading 0)
You may be able to just change the number format
format|cells|number tab|custom category: 00000
to show the leading 0's.
Smooney wrote:
I have a column containing serial numbers but some of those numbers have an
'S' in front of them. Is there a way to delete the 'S' from all the cells
but leave the number there?
--
Dave Peterson
|