Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 342
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract portion of cell contents Rick[_10_] Excel Worksheet Functions 7 December 19th 09 12:27 AM
Repeating only a portion of both row and column on multiple pages Tmarkos Excel Discussion (Misc queries) 1 March 4th 09 09:58 PM
delete contents of cell RDC Excel Discussion (Misc queries) 1 January 21st 09 04:13 PM
Delete cell contents Rob[_4_] Excel Discussion (Misc queries) 7 April 10th 07 12:34 PM
Delete row based on contents of cell AndyG Excel Discussion (Misc queries) 6 November 17th 05 10:08 PM


All times are GMT +1. The time now is 05:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"