ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I delete a portion of cell contents repeating in multiple fie. (https://www.excelbanter.com/excel-discussion-misc-queries/256807-can-i-delete-portion-cell-contents-repeating-multiple-fie.html)

katkim

Can I delete a portion of cell contents repeating in multiple fie.
 
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.

TomPl

Can I delete a portion of cell contents repeating in multiple fie.
 
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




All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com