/Excel-Queries-cheat-sheet

Excel queries to assist pentester/bugHunter during an engagement. Make excel less boring task

Extract Sub-Domain + Domain from URL

=SUBSTITUTE(REPLACE(REPLACE(A2; 1; IFERROR(FIND("//"; A2)+1; 0); "")&"/"; FIND("/"; REPLACE(A2; 1; IFERROR(FIND("//"; A2)+1; 0); "")&"/"); LEN(A2); ""); "www."; "")