Question for all you MS Excel wizards

[downtown]

Okay, I need help with something here.

I have this huuuuge spreadsheet (over 1500 cells), and I need to assign a new column to it. The info I need is kinda in another column, so this new one is just to help set up teh data better.

Is there a way I can have the program search for a certain word, and then add that word into another collumn? Like, search column X for word Y...and then put Y into Column Z. All I know how to do is search and replace in the same column. I dont have to write a Macro, do i?

 

[Conroe]

Sounds like you might be looking for the "Find" function. It will search a text string for a matching pattern (word) and return the starting position of the match.

=find("word Y",col_X,1)

 

[Souron]

Okay, I need help with something here.

I have this huuuuge spreadsheet (over 1500 cells), and I need to assign a new column to it. The info I need is kinda in another column, so this new one is just to help set up teh data better.

Is there a way I can have the program search for a certain word, and then add that word into another collumn? Like, search column X for word Y...and then put Y into Column Z. All I know how to do is search and replace in the same column. I dont have to write a Macro, do i?

You can have a column that displays a set message on a set row if the another column satisfies a criteria on that row. You can have multiple criteria and messages. However, the new column will not be able to condense itself to a short list of words with no blanks for rows with no words.

So each cell in the new column should look something like this:
=IF(ISERROR(FIND("Find Me",A1)),"","FIND ME")

 

[downtown]

awesome, thanks guys