| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting a consistant portion of all cells in a given column | Excel Worksheet Functions | |||
| combine information in two cells into the third column | Excel Discussion (Misc queries) | |||
| How can I copy information from one column, but not balnk cells? | Excel Discussion (Misc queries) | |||
| merging information from partial duplicate rows | Excel Discussion (Misc queries) | |||
| Deleting blank cells in a column | Excel Discussion (Misc queries) | |||
Linear Mode
