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

[์—‘์…€] CONCATENATE ํ•จ์ˆ˜ ๋ฌธ์ž์—ด ํ•ฉ์น˜๊ธฐ :: ๋งˆ์ด์ž๋ชฝ

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

CONCATENATE ํ•จ์ˆ˜

์…€๊ฐ’ ๋˜๋Š” ๋ฌธ์ž์—ด์„ ๊ฒฐํ•ฉํ•ด์ฃผ๋Š” ํ•จ์ˆ˜


ํ•จ์ˆ˜ ์‚ฌ์šฉ๋ฒ•

์ธ์ž๋“ค์— ๊ฒฐํ•ฉํ•  ๋ฌธ์ž๋ฅผ ์ฐจ๋ก€๋Œ€๋กœ ๋‚˜์—ด

1
=CONCATENATE(๋ฌธ์ž1,๋ฌธ์ž2,๋ฌธ์ž3,...)
cs
๊ฒฐ๊ณผ : ๋ฌธ์ž1๋ฌธ์ž2๋ฌธ์ž3




๊ฒฐ๊ณผ

1
=CONCATENATE(A2," ",B2,"์›")
cs



๋Œ“๊ธ€