<div>
I am getting values as per your formula 323 &amp;&nbsp;69540.<br />
<br />
I don't seem any fault.<br />
<br />
thanks
</div>


I am getting values as per your formula 323 & 69540.

I don't seem any fault.

thanks

<div>
just one try - change format to Text &amp;&nbsp;then apply formula for that range.<br />
<br />
Thanks
</div>


just one try - change format to Text & then apply formula for that range.

Thanks

<div>
Are &nbsp;there are characters after Out=69540?
</div>


Are  there are characters after Out=69540?

<div>
Hi,<br />
Try this one with number format, if it is working, then change the text format.
</div>


Hi,
Try this one with number format, if it is working, then change the text format.

<div>
Could you provide a sample file with some of the lines you pasted? &nbsp;Maybe we can replicate the issue and resolve.<br />
<br />
-Glenn
</div>


Could you provide a sample file with some of the lines you pasted?  Maybe we can replicate the issue and resolve.

-Glenn

<div>
Cheers that was it, I had hyperlink into source column and that was causing the error.
</div>


Cheers that was it, I had hyperlink into source column and that was causing the error.

<div>
<div class="content wysiwyg-content">
Heyas,<br />
<br />
I copied some data from report and pasted into the excel the lines look something like this.<br />
<br />
[Random Alphanumeric Chars of Varying Lengths] In=323 Out=69540 [Random Alphanumeric Chars of Varying Lengths].<br />
<br />
What I am looking to do is extract the 'In' and 'Out' values into to separate columns.<br />
<br />
I am using the following formula's but it doesn't work at all, all I am getting is #VALUE and I don't understand why.<br />
<br />
=REPLACE(REPLACE(A1,FIND(&quot;<wbr /> &quot;,A1,FIND(&quot;In=&quot;,A1)),LEN(A<wbr />1),&quot;&quot;),1,F<wbr />IND(&quot;In=&quot;,<wbr />A1)+2,&quot;&quot;)<br />
=REPLACE(REPLACE(A1,FIND(&quot;<wbr /> &quot;,A1,FIND(&quot;Out=&quot;,A1)),LEN(<wbr />A1),&quot;&quot;),1,<wbr />FIND(&quot;Out=<wbr />&quot;,A1)+3,&quot;&quot;<wbr />) <br />
<br />
Any ideas?
</div>
</div>


Heyas,

I copied some data from report and pasted into the excel the lines look something like this.

[Random Alphanumeric Chars of Varying Lengths] In=323 Out=69540 [Random Alphanumeric Chars of Varying Lengths].

What I am looking to do is extract the 'In' and 'Out' values into to separate columns.

I am using the following formula's but it doesn't work at all, all I am getting is #VALUE and I don't understand why.

=REPLACE(REPLACE(A1,FIND(" ",A1,FIND("In=",A1)),LEN(A1),""),1,FIND("In=",A1)+2,"")
=REPLACE(REPLACE(A1,FIND(" ",A1,FIND("Out=",A1)),LEN(A1),""),1,FIND("Out=",A1)+3,"") 

Any ideas?

Extracting Specifc  Text from Excel String (In, Out Values)

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.