Insert each word in different cell in Excel


#1

Hi, I have a requirement that extract data from a PDF and each word of the PDF insert into an Excel in each cell. Means For one word one cell in excel and for next word next cell accordingly.
Can anyone please suggest me on this ?


#2

One way is split your string tab delimited(row paste) or Environment.Newline delimited (Column paste) and copy to clipboard.

Ctrl+V on excel

Or

Use the split data and and add it to data table


#3

Hi @vvaidya,
Thank you for your replay.
Can you please elaborate with a small example?
Thanks,
Koushik


#4

Example for pasting, this looks fun but slow process. You can use add data row instead using the existing logic.(You will get many samples if you search)

It pasts every letter cell by cell, if encounters space goes to next row (you can manipulate this)

pasteCells.xaml (11.3 KB)


#5

Hi @vvaidya,
It is now pasting each letter in a cell, I want each word in a cell.
Anyway Thanks again for your help. :slight_smile:


#6

Thought you wanted letter, if word you can split your string by space

Split(Word," ") and do foreach


#7

Now it’s working.
Thank you so much. :slight_smile: