Simulate TAB Key when Copying & Pasting multiple Values

[lipster]

Hi Everyone,

I have a longggg list of words in excel, 10,000 columns long. I need to copy/drag each word into a single text box/field in an external application and do that 10,000 times. Laborious!

Is there a way to simulate the TAB character between each word within excel (E.g. word1<TAB>word2<TAB>word3<TAB>) all in one cell of course, so that if I was to drag/copy this cell from excel and then drop/paste it into the first text box of the external application, the first box would contain word1, the second box word2 etc...

word1

word2

word3

Thanks in Advance,

Lipster

[monoceres]

Hi and welcome to the forums.

Seems like you could do this much easier with the excel udf.

Take a look int help file under Excel Management in the UDF section.

[Juvigy]

I guess you want to send the 10000 words with autoit with the external application? right?

It could be easily done. Just put each word from excel to array - _ExcelReadArray and then create a loop to send each word from the array to the external app and then send "tab" ...