Archive of Mr Excel Message BoardArchive of Mr Excel Message Board
A) Let's say you have a file with 10 bullet
points, each on a separate row A1 through A10.
B) You need to copy these bullets into a simple text
box - each on a separate row
Here's the dilemma:
1) Other than coping each row individually, How
can I get this data into a text box - so that
the Text box can be copied to another file.
* Selecting the rows & using copy, doesn't work.
Any and all suggestions are welcome
Well, this is probably more work than you want, but here is what I tried, and it worked:
select the column of cells
choose copy
open MS-Word and paste
highlight the whole selection in Word and then convert Table to Text
Now you can copy it into your text box.
(void where prohibited by law, batteries not included, this end up.)
RBY
Hi BD
Select cells A1:A10
Hold down the Shift key
Go to Edit>Copy Picture
Make your choice
Paste where you like.
Dave
OzGrid Business Applications
This no worky inside textbox. Paste option not availble for the resultant "picture" into a textbox.
I don't know why you would want to place the "Picture" inside a Textbox, but if you must.
Drag the Picture inside the TextBox
Size and format it accordingly
Now from the "Drawing Toolbar" click the "Select Objects" arrow and select both the Picture and the TextBox.
Now righjt click and go to Grouping>Group.
That better ?
Dave
OzGrid Business Applications