Deleting partial information from all cells in a column
 

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?

Deleting partial information from all cells in a column
 

Edit|Replace?

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

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

Deleting partial information from all cells in a column
 

Select the column of data.

Go into Replace and insert S as Find what to replace and leave the Replace
blank and click Replace all.

Tip: Ensure you have a backup of your workbook when performing these type of
operations.

Regards,

OssieMac

"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?

Deleting partial information from all cells in a column
 

You are brilliant!! Don't know why I couldn't think of that...so simple.
Thanks tons!!

S.

"OssieMac" wrote:

Select the column of data.

Go into Replace and insert S as Find what to replace and leave the Replace
blank and click Replace all.

Tip: Ensure you have a backup of your workbook when performing these type of
operations.

Regards,

OssieMac

"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?