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