Search method

[hmmm...]

I'm looking for the opposite of the Excel function "concatenate" or "&", so I can remove a character from a text string. So in Google I typed "excel opposite concatenate". The first result returned was:

Mr Excel Message Board for Excel Help Forums - View Forum
... The opposite of concatenate? ... than 7 Posts) = Topic is Locked (No new Posts may be
made in it), Next Page | Select a Forum Excel Forums ----- Excel ...
www.mrexcel.com/board/viewforum.php?forum=14&958 - 22k - Cached - Similar pages

The link put me on the MrExcel home page. I then used the MrExcel search function to try to find a post containing "The opposite of concatenate?" but I can't find it. Maybe I'm not seaching correctly?

Thanks!

 

[Juan Pablo González]

This one perhaps ?

http://www.mrexcel.com/board2/viewtopic.php?t=889

 

[hmmm...]

That's it; thanks very much.

Is there a way to search for the exact phrase--how did you find it?