Can I delete a portion of cell contents repeating in multiple fie.
in [General]
|
Prev: How can I remove the previous lock cells and keep the new ones.
Next: how do I put quotes around a field in Excel 2007
From: katkim on 19 Feb 2010 11:20 I want to delete a portion of cell contents that repeat throughout a single column. For example: Row 1, Col 1 entry is "Phone: (888)000-000", Row 2, Col 1 entry is "Phone: (888)001-1112", etc. I want to delete only "Phone:" from all the cells without deleting the rest of the cells' entries.
From: tompl on 19 Feb 2010 11:25
You could select all of the cells that you are interested in modifying the search for “Phone:” and replace with nothing. Ctrl H brings up search and replace. Tom |