FIND

Returns the position of a string of text within another string.You can also define where to begin the search. The search term can be a number or any string of characters. The search is case-sensitive.

๊ตฌ๋ฌธ

FIND("FindText"; "Text" [; Position])

FindText๋Š” ์ฐพ์€ ํ…์ŠคํŠธ์„ ์ฐธ์กฐํ•ฉ๋‹ˆ๋‹ค.

Text๋Š” ๊ฒ€์ƒ‰ํ•  ์œ„์น˜์— ์žˆ๋Š” ํ…์ŠคํŠธ์ž…๋‹ˆ๋‹ค.

Position์€ ํ…์ŠคํŠธ ๋‚ด์—์„œ ๊ฒ€์ƒ‰์„ ์‹œ์ž‘ํ•  ์œ„์น˜์ž…๋‹ˆ๋‹ค. (์„ ํƒ ์‚ฌํ•ญ)

์˜ˆ์ œ

=FIND(76;998877665544)๋Š” 6์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

Please support us!