Deleting partial information from all cells in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Edit|Replace?
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?
Click to expand...
 
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.
 
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
 
You are brilliant!! Don't know why I couldn't think of that...so simple.
Thanks tons!!

S.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing two columns for partial values 7
With F1 value, look at A, if match or partial match return B 5
Comparing numbers in one column with numbers in another column. 6
Last Modified By in a cell by user 3
Column Lookup? 3
deleting numbers in a column 2
Reference the same cell based on tab name 1
Separating data in the same cell 1

Back
Top