=LET(txt,A2,
    HSTACK(
        REGEXEXTRACT(txt,"[가-힣]{2,3}"),
        REGEXEXTRACT(txt,"(?<=\()[MF](?=\))|(?<![가-힣])[MF](?![가-힣])"),
        REGEXEXTRACT(txt,"[a-zA-Z0-9._-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}"),
        REGEXEXTRACT(txt,"010-\d{4}-\d{4}"),
        REGEXEXTRACT(txt,"\d{4}[-/]\d{1,2}[-/]\d{1,2}"),
        REGEXEXTRACT(txt,"[\d,]+(?=\s*(?:원|달러|유로))"),
        REGEXEXTRACT(txt,"원|달러|유로")
    )
)

상위버전 함수로 하니 깔끔하네요...

전 2021버전이라 파워쿼리로

힌트 : 조건열

​

=LET(rngCn,B3:B32, xSS,SUBSTITUTE(rngCn,CHAR(160)," "),
xName,REGEXEXTRACT(xSS,"^\s*([가-힣]+)"), xMF,REGEXEXTRACT(xSS,"\(([MF])\)"), xMail,REGEXEXTRACT(xSS,"[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}"),
xPhone,REGEXEXTRACT(xSS,"01[016789]-\d{3,4}-\d{4}"), xD,REGEXEXTRACT(xSS,"(?:19|20)\d{2}[-/]\d{2}[-/]\d{2}"), xDate,IFERROR(REGEXREPLACE(xD,"/","-"),""),
xA,REGEXEXTRACT(xSS,"(\d{1,3}(?:,\d{3})*|\d+)\s*(?=원|달러|유로)"), xAmt,IF(xA="","",TEXT(VALUE(SUBSTITUTE(xA,",","")),"#,##0")),
xUnit,REGEXEXTRACT(xSS,"(원|달러|유로)"),
HSTACK(xName, xMF, xMail, xPhone, xDate, --xAmt, xUnit))

=LET(Area,B2:B31,
이름,"([가-힣]+)(?=\([FM]\))",
성별,"\(([FM])\)",
이메일,"([A-Za-z0-9\.\_\+\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})",
전화번호,"(\d{3}-\d{4}-\d{4})",
날짜,"(\d{4}[\/\-]\d{2}[\/\-]\d{2})",
금액,"([\d,]+)\s*(?=원|달러|유로)",
단위,"[\d,]+\s*(원|달러|유로)",
HSTACK(REGEXEXTRACT(Area,HSTACK(이름,성별,이메일,전화번호),2),
--REGEXEXTRACT(Area,HSTACK(날짜,금액),2),REGEXEXTRACT(Area,단위,2) ))