It's the starting position for the search. The default is 1, so I didn't have
to use it.

But if I wanted to ignore the first 2 characters, I could:
=SEARCH("x",A1,3)
so if A1 contained: xxasdfxqwer
that formula would return: 7

Excel's help is a nice spot to look for these kinds of questions <bg.


Emory Richter wrote:

Dave
Thanks for the methods.
One thing,
In SEARCH("x",A1,1)
I understand that the "x" is the thing_to_search
and A1 is the source.
What is the third item, the 1?

In article , ec35720
@netscapeXSPAM.com says...
Everything before the x:
=--LEFT(A1,SEARCH("x",A1,1)-1)

Everything after the x:
=--MID(A1,SEARCH("x",A1,1)+1,255)

=left() and =mid() both return strings. If you want to use those values as
numbers, you can convert them by using -- in front of the expression.

=search() and =find() are very similar functions. =Find() is case sensitive.
=search() is not.

Emory Richter wrote:

I have cells with numbers of various character counts
seperated by an "x".

eg.
2x1.5
48x3

I can find the "x" position with the MID function.

Now how do I extract
ALL numbers to the right of the "x"
or
ALL numbers to the left of the "x" ?

Thank you,
Emory



--

Dave Peterson