finnstone
asked on
insert formulas into column e,f,g across 800 csv files
i need to insert these formula into every workbook in 499 rows , putting them in column e,f,g,
=MID(b1,FIND("http",b1),IF ERROR(FIND (" ",b1,FIND("http",b1))-1,LE N(b1))-FIN D("http",b 1)+1)
=MID(c1,FIND("http",c1),IF ERROR(FIND (" ",c1,FIND("http",c1))-1,LE N(c1))-FIN D("http",c 1)+1)
=MID(d1,FIND("http",d1),IF ERROR(FIND (" ",d1,FIND("http",d1))-1,LE N(d1))-FIN D("http",d 1)+1)
thanks!
=MID(b1,FIND("http",b1),IF
=MID(c1,FIND("http",c1),IF
=MID(d1,FIND("http",d1),IF
thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
it keeps breaking after only ten files
i think it loses its place?
i think it loses its place?
ASKER
ah never mind. some files were corrupted
ASKER