In A1 I have abc/123 and in B1 the formula I used was
=MID(A1,FIND("/",A1,1)+1,LEN(A1)-FIND("/",A1,1))
Hope this helps.
--
David


"Sami82" wrote:



Hi All,

I need to create a macro (to sit within another macro) which looks at a
string of text and copies the 8 characters after it. For example

line:
customer name invoice 1254254875
$12,053.33

String to look for (may be on various lines)
invoice

string to copy
1254254875

Thank you.


--
Sami82
------------------------------------------------------------------------
Sami82's Profile: http://www.excelforum.com/member.php...o&userid=27111
View this thread: http://www.excelforum.com/showthread...hreadid=482117