Replace Cell Text Leaving 1 Word

sanjana · Jul 10th 2007

Hi

I am looking for a syntax or function wherin i can replace all lines in different cells containing specific string or text in it.

e.g. Few cells in sheet contains " This guy is for deployment", other few cells may contain "guy is for core deployment" and other cells may have " project is specific deployment". I want to replace all such lines which contain a word "deployment" with ony one word "Deployment"..... Any clue???

Thanks

Dave Hawley · Jul 10th 2007

Re: Replace Complete Line With Specific String In It

Select the range, if not the whole sheet and go to Edit>Replace and replace: *deployment* with: Deployment. Or, just ensure the Whole cells only is NOT checked and replace: deployment with Deployment

**Krishnakumar** · Jul 10th 2007

Re: Replace Complete Line With Specific String In It

Hi,

Hit Ctrl+H

find what: *deployment*
Replace with: Deployment

HTH

xlite · Jul 10th 2007

Re: Replace Complete Line With Specific String In It

hi,

in yr sheet press Ctrl F,
in the Find what type deployment
in the replace with type Deployment

click on Replace All

Dave Hawley · Jul 10th 2007

Re: Replace Complete Line With Specific String In It

Snap

xlite · Jul 10th 2007

Re: Replace Cell Text Leaving 1 Word

hi Kris,

i didn't know Ctrl + H calls the same function
Cool

**Krishnakumar** · Jul 10th 2007

Re: Replace Cell Text Leaving 1 Word

Quote from xlite

hi Kris,

i didn't know Ctrl + H calls the same function
Cool

So you learned something today

xlite · Jul 10th 2007

Re: Replace Cell Text Leaving 1 Word

Quote from Krishnakumar

So you learned something today

yeap definitely something new, thx

Replace Cell Text Leaving 1 Word

Participate now!

Share