I have one excel spread sheet that have 4 sheets, which
is sheet1, sheet2, sheet3, sheet4, on each sheets of
columns A that has data like this "
C#1251934538L#0000000169R#00002P#00001", I need to strip
out C#1251934538 and R#00002P#00001, all I need is
L#0000000129, another word is before L need to strip out,
and after 9 from R need to strip out as well. how to
write the macro to do that, also this need to in the loop
for sheet1, sheet2, sheet3, sheet4.

Simple word is the data I need is from L to last numeric
no, before R. which is L#0000000129

thanks.


Lillian