hi!
I guess this is a typical novice question.
Is there a way to split a data column horizontally? (please see attached)
Many thanks!
hi!
I guess this is a typical novice question.
Is there a way to split a data column horizontally? (please see attached)
Many thanks!
Tools> Text to Columns will do what you need.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
thanks mike!
I meant vertically. sorry for the mistake.
CharlizePlease Login or Register to view this content.
hi Charlize,
sorry for the late reply.
reason: I just learnt how to use macros today.
your code works neatly.
one outstanding question:
it didn't seem responding when i tried to run it on the second sheet of the same file.
any hint?
regards
ChangetoPlease Login or Register to view this content.
CharlizePlease Login or Register to view this content.
got it!
best regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks