Sting search in Excel

[pgflrob]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I want to write a function in a cell that searches for a string in a cell with text and returns that string if it is found in the text. It works unless the string is not fund in the cell I am searching. I get "#value! but want a blank if the string is not found.

 

[macropod]

Hi pgflrob,

embed your search string in an IF test coded along the lines of:
=IF(ISERROR(SEARCH(parameters)),"",SEARCH(parameters))

 

[pgflrob]

Thank you. Perfect.

Is there a good training book on MS Office 2008, I have been a user for a long time but several older and new features escape me. For example I do not know how to pivot in Excel and I was working collaboratively on a powerpoint, opened a new file and built this graphic, I dumped it into the old ppt and all the colors were different and ugly. This was my first intro to "themes" and templates (I have used slide masters somewhat). I would like to know how to work with themes an even modify them.

There are several features in Word I would like to gain skills in like multi-column work and the ins and outs of creating and "pasting" graphics and charts.

Not sure if these are considered advanced features but I need to learn them.

Thanks, again.

 

[Jim Gordon Mac MVP]

Thank you. Perfect.

Is there a good training book on MS Office 2008, I have been a user for
a long time but several older and new features escape me. For example I
do not know how to pivot in Excel and I was working collaboratively on a
powerpoint, opened a new file and built this graphic, I dumped it into
the old ppt and all the colors were different and ugly. This was my
first intro to "themes" and templates (I have used slide masters
somewhat). I would like to know how to work with themes an even modify
them.

There are several features in Word I would like to gain skills in like
multi-column work and the ins and outs of creating and "pasting"
graphics and charts.

Not sure if these are considered advanced features but I need to learn
them.

Thanks, again.

Hi,

The first place to find great assistance is simply to click the blue
question mark (help) button on the standard toolbar. Of course, my book
is also a great reference tool.

-Jim