Hi,
I need your help once more
I have data in csv:
that I import to different excel sheet so I'm getting
after using split
I'm getting
My final goal is:
any ideas?
Thanks,
I need your help once more
I have data in csv:
word1,"word2 "word2" "word2" word2","word3","word4","word5","word6"
that I import to different excel sheet so I'm getting
"word1,""word2 ""word2"" ""word2"" word2"",""word3"",""word4"",""word5"",""word6"""
after using split
Split(value, ",")
I'm getting
"word1 | ""word2 ""word2"" ""word2"" word2"" | ""word3"" | ""word4"" | ""word5"" | ""word6""" |
My final goal is:
word1 | word2 "word2" "word2" word2 | word3 | word4 | word5 | word6 |
any ideas?

Thanks,