Tip:
Highlight text to annotate it
X
Please subscribe and support this channel, you can support by given a comment or a like to the video.
thank's
Create a list of words, or keywords, and convert them with separated comma between them?
on a csv file, and want to paste them else where, paste them as tags?
Here I have a list of one hundred and one words, and I want to put a comma in front of each one
i'm going to copy, and paste in another worksheet in excel
as you can see, there's no comma
let's make a function, to modify this
equal, A1,&,quotes, comma, closing quotes
now, let's do to the other words
copping and pasting the same function to the other cells
we have a comma, yes, but we can't paste them because they have no value, it's just a function
we have to get the value, and this is how we do it
select the words you want to convert, and copy it
now press control-command-v
choose, values
now we can paste them else where, because they are a value
let's open text edit, to see how they look
we paste them in a column form, let's try in a row method
select and copy again, press control-command-v, and choose transpose
paste them, and now we have the data in a row
This is how we do it, to convert keywords separated with a comma
but, i make a small excel file, that makes easy and quickly to do this
just grab your keywords, copy and paste to convert them
now paste it in
click convert button
click copy to paste else where
Thank you for watching, and if you like to have this file, just let me know.
If you like this video, please hit the like button
thank's