CSV. This is the acronym for comma separated values or Cash Surrender Value (if you are selling insurance). But this is not an insurance blog so I'll stick with the former definition. If you work with data, sometimes you get it in one format and you've got to put it into another format to get more data. In this case you get a list of values in a column and you'd need to take that list and input it into some program to get more data. But the input there is one input field and it takes the list in a CSV format. Basically all those separate values together, but separated by commas. This task is not so bad if you've got a few values like this:
1

2

3

Then you'd just need to convert this to the CSV format of 1,2,3.

But what if you had a hundred values? or maybe a thousand values? Doing this manually would just suck all the time from your life. Well here's Excel to the rescue. You can actually do this quite easily. So check out the video to see how.

0:00 Intro
1:30 CONCATENATE Function
2:34 Fill Handle to Copy Formula


🔔 SUBSCRIBE to my channel ➜ [ Ссылка ]

🏫 Excel Training ➜ [ Ссылка ]

📚 Excel Books & Tech Gear ➜ [ Ссылка ]

⚙️ Tools: Screencasting ➜ [ Ссылка ]

⚙️ Tools: Microsoft Office ➜ [ Ссылка ]

⚙️ Tools: TubeBuddy ➜ [ Ссылка ]

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

🎁 If you find these videos useful and want to support my channel go to [ Ссылка ]

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
[ Ссылка ]
-~-~~-~~~-~~-~-

свернуть