Simple code to locate a word and remove space in front

**yiannis1925** · 12-13-2011, 07:09 AM

Hello,

I need a code to locate some words from a list in Sheet2 and Column A
in Sheet1 and Column C and remove the space in front of these words in Sheet1/Column C

example
sheet2
word
test

sheet1 (should become after running the code)
remove wordspace
testspace
wordare small
space testshould go

Thank you in advance.

**JBeaucaire** · 12-13-2011, 08:23 AM

Try this:

Please Login or Register  to view this content.

**Jollyfrog** · 12-13-2011, 08:28 AM

something like:

if there are more than 10 words, x will need to be changes to x = 1 to (number of words in list)

Please Login or Register  to view this content.

**Jollyfrog** · 12-13-2011, 08:29 AM

rats.. someone beat me to it

**JBeaucaire** · 12-13-2011, 08:35 AM

No worries, JF, we are a village. It's not a race...

As a teaching forum, be sure to declare your variables.

Also, your macro is making changes outside of column C due to your Cells. reference. Edit that back to just column C and remove the unnecessary .Select. And I believe the words to replace are on Sheet1.