๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
์—‘์…€/ํ•จ์ˆ˜

[์—‘์…€] FIND SEARCH ์‚ฌ์šฉ๋ฒ• & ์ฐจ์ด์  :: ๋งˆ์ด์ž๋ชฝ

by ๐ŸŒปโ™š 2019. 1. 20.

FIND SEARCH ํ•จ์ˆ˜

FIND์™€ SEARCH ๋‘ ํ•จ์ˆ˜ ๋ชจ๋‘ ๊ธฐ๋Šฅ์€ ๊ฐ™๋‹ค.
๋ฌธ์ž์—ด ํ˜น์€ ๋ฒ”์œ„์—์„œ ํŠน์ • ๋ฌธ์ž ํ˜น์€ ๋ฌธ์ž์—ด์„ ๊ฒ€์ƒ‰ํ•˜์—ฌ ์กด์žฌํ•˜๋ฉด ๋ฌธ์ž์˜ INDEX๊ฐ’์„ ๋ฐ˜ํ™˜ํ•œ๋‹ค.



FIND SEARCH ์ฐจ์ด์ 

FIND
๋Œ€์†Œ๋ฌธ์ž ๊ตฌ๋ถ„ : O
์™€์ผ๋“œ์นด๋“œ ๋ฌธ์ž ์‚ฌ์šฉ : X

SEARCH
๋Œ€์†Œ๋ฌธ์ž ๊ตฌ๋ถ„ : X
์™€์ผ๋“œ์นด๋“œ ๋ฌธ์ž ์‚ฌ์šฉ : O


์™€์ผ๋“œ์นด๋“œ ๋ฌธ์ž์— ๋Œ€ํ•œ ์„ค๋ช…์€ ์•„๋ž˜ ๋งํฌ๋ฅผ ํ™•์ธํ•œ๋‹ค.

http://myjamong.tistory.com/65



FIND SEARCH ์‚ฌ์šฉ๋ฒ•



B2 : "Jamong@abc.com"

F2์…€ ๋‚ด์šฉ

FINDํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ด์„œ "jamong"์ด ๋“ค์–ด์žˆ๋Š”์ง€ ํ™•์ธํ•œ๋‹ค.

1
=FIND("jamong",B2)

cs

FINDํ•จ์ˆ˜๋Š” ๋Œ€์†Œ๋ฌธ์ž๋ฅผ ๊ตฌ๋ถ„ํ•˜์—ฌ "jamong"์„ B2์—์„œ ๋ชป์ฐพ๊ณ  ์žˆ๋‹ค.


F3์…€ ๋‚ด์šฉ

SEARCHํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ด์„œ "jamong"์ด ๋“ค์–ด์žˆ๋Š”์ง€ ํ™•์ธํ•œ๋‹ค.

1
=SEARCH("jamong",B2)
cs

SEARCHํ•จ์ˆ˜๋Š” ๋Œ€์†Œ๋ฌธ์ž๋ฅผ ๊ตฌ๋ถ„ํ•˜์ง€ ์•Š์•„ "Jamong"์„ B2์—์„œ ์ฐพ์•„ Index ๊ฐ’์ธ 1์„ ๋ฐ˜ํ™˜ํ•œ๋‹ค. 



F4์…€ ๋‚ด์šฉ

FINDํ•จ์ˆ˜๋ฅผ ์™€์ผ๋“œ์นด๋“œ ๋ฌธ์ž์™€ ๊ฐ™์ด ์‚ฌ์šฉํ•ด์„œ  "Ja*" ์ด ๋“ค์–ด์žˆ๋Š”์ง€ ํ™•์ธํ•œ๋‹ค.

1
=FIND("Ja*",B2)
cs

FINDํ•จ์ˆ˜๋Š” ์™€์ผ๋“œ์นด๋“œ ๋ฌธ์ž๋ฅผ ์‚ฌ์šฉํ•˜์ง€ ๋ชปํ•ด "Ja*" ๋ฌธ์ž์—ด ๊ทธ๋Œ€๋กœ B2์—์„œ ๊ฒ€์ƒ‰ํ•˜์—ฌ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•˜์ง€ ๋ชปํ•œ๋‹ค.


F5์…€ ๋‚ด์šฉ

SEARCHํ•จ์ˆ˜๋ฅผ ์™€์ผ๋“œ์นด๋“œ ๋ฌธ์ž์™€ ๊ฐ™์ด ์‚ฌ์šฉํ•ด์„œ  "Ja*" ์ด ๋“ค์–ด์žˆ๋Š”์ง€ ํ™•์ธํ•œ๋‹ค.

1
=SEARCH("Ja*",B2)
cs

SEARCHํ•จ์ˆ˜๋Š” ์™€์ผ๋“œ์นด๋“œ ๋ฌธ์ž๋ฅผ ์‚ฌ์šฉํ• ์ˆ˜ ์žˆ์–ด "Jamong"๊ฐ’์„ B2์—์„œ ์ฐพ์•„ Index ๊ฐ’์ธ 1์„ ๋ฐ˜ํ™˜ํ•œ๋‹ค.



FIND SEARCH ์‘์šฉ ์˜ˆ์ œ

์ž๋ชฝ์Šˆํผ ํšŒ์›๋‹˜๋“ค์˜ ์ด๋ฉ”์ผ ์ฃผ์†Œ๊ฐ€ ํ‘œ์‹œ๋œ ํ…Œ์ด๋ธ”์ด ์žˆ๋‹ค.
์ด๋ฉ”์ผ ์ฃผ์†Œ์—์„œ '@'๋ฌธ์ž๋ฅผ ๊ธฐ์ค€์œผ๋กœ ์ขŒ์ธก์— ์žˆ๋Š” ID๊ฐ’๋งŒ ์ถ”์ถœํ•ด์„œ ID์—ด์— ํ‘œ๊ธฐํ• ๋ ค๊ณ ํ•œ๋‹ค.


๊ฒฐ๊ณผ


C2์…€ ๋‚ด์šฉ

1
=IF(ISNUMBER(SEARCH("@",B2)),LEFT(B2,FIND("@",B2)-1),"")
cs

B2 : "Jamong@abc.com"

๊ฒฐ๊ณผ : SEARCH ํ•จ์ˆ˜๋กœ "@"๋ฌธ์ž๊ฐ€ "Jamong@abc.com"์— ํฌํ•จ ๋˜์–ด์žˆ๋Š”์ง€ ํ™•์ธํ•˜์—ฌ ์ˆซ์ž๊ฐ’("@"๊ฐ€ ํฌํ•จ ๋˜์–ด์žˆ๋‹ค๋Š” ๋œป)์ด ๋ฐ˜ํ™˜๋˜๋ฉด "Jamong@abc.com"์—์„œ ๋ฌธ์ž "@"๊ฐ€ ์žˆ๋Š” ์œ„์น˜๋กœ๋ถ€ํ„ฐ ์™ผ์ชฝ ๋ฌธ์ž์—ด๋งŒ ์ถœ๋ ฅํ•œ๋‹ค.

์ˆซ์ž๋ฅผ ๋ฐ˜ํ™˜ํ•˜์ง€ ์•Š์œผ๋ฉด ""๋ฅผ ๋ฐ˜ํ™˜ํ•œ๋‹ค.



๋Œ“๊ธ€