Loop Through Range, Find Text, and Replace Text

**EnigmaMatter** · 09-09-2014, 08:16 AM

Hello, I have a column in Table1 that contains "West" and "West ". I want to loop through that column and replace all entries of "West " with "West".

**Izandol** · 09-09-2014, 08:19 AM

You may use Replace method of range:

Please Login or Register  to view this content.

**Vikas_Gautam** · 09-09-2014, 08:28 AM

1. Select your column
2. Press Ctrl + F
3. Write "West " and Replace with "West" (without Quotes)

I think this will do.. Don't forget to select Column

**EnigmaMatter** · 09-09-2014, 12:01 PM

I didn't think that would work in VBA, but it did.

Loop Through Range, Find Text, and Replace Text

LinkBack

Thread Tools

Rate This Thread

Display

Loop Through Range, Find Text, and Replace Text

Re: Loop Through Range, Find Text, and Replace Text

Re: Loop Through Range, Find Text, and Replace Text

Re: Loop Through Range, Find Text, and Replace Text

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find & Replace Formula for Locating Short Text within Larger Text

[SOLVED] VBA - Macro - Loop - Data - find "normal text" IE. File name - replace list exhausted

Run Time Error '6' Overflow - Macro That Find Text and Copy Range & Replace on Other Sheet

[SOLVED] VBA to Search a Text String, Find a Value listed in another column and replace the text

find in excel replace in word: find/replace text in text boxes and headers

Bookmarks

Bookmarks

Posting Permissions