PDA

View Full Version : Solved: Paste data with adding spaces between letters



hunna
11-27-2011, 04:17 PM
Hi there,

I have a certain data copied from text file, for example "ASEWDYFKS".

I want to have a macro that I can assign a range to input such data,

supposed that the first range to be input is A3

so I expect the output would be

in range A3 -- > A
in range B3 -- > S
in range C3 -- > E
.
.
.
in range I3 -- > S

------------------------------

I have a macro that can manage this task but it's quite slow. I first paste "ASEWDYFKS" into textbox1 (in Userform) and add "3" into textbox2 (in Userform).


My macro then pastes the data (textbox1) to a certain range followed by adding spaces between letters, text to column and then pastes to a desired range.



------------------------------

any help would be appreciated,

thanks,


PS I am not sure if it's clear, sorry for my english

Trebor76
11-27-2011, 04:44 PM
Cross posted, and potentially solved, here (http://www.mrexcel.com/forum/showthread.php?t=595012)