Can I delete a portion of cell contents repeating in multiple fie.

K

katkim

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.
 
T

tompl

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
 

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

Top