TSB
Artist => General Art Discussions => Topic started by: XG Print on April 21, 2017, 01:54:59 PM
-
About to do some class shirts for several schools. I have been sent lists of names in an Excell document. How do I go about importing these names into Corel in a format where I can change fonts and sizes once in Corel. This would be a huge help and keep us from retyping a thousand or so names.
Thanks
-
Open the Excell document.
( If you don't have Excell, you can download OpenOffice, and open it with that. )
Highlight column of names.
CTRL-C ( Copy ).
Create new text document. Open it. CTRL-V ( Paste ).
Now everything is just plain text with no formatting.
Copy that.
Open Corel. Select text tool. * click on your workspace area somewhere*
Paste.
You can skip the text document sometimes, and paste directly in Draw, but not always.
-
if they are a listed with each name in individual cells and are listed vertical. then best way to import them with them keeping the same vertical list as what you have in excel then highlight the cells you want, then save the selected cells as a web page, check the box which says open when saved and it will open in your browser from there you can highlight copy paste to corel. if you paste direct to open page in corel then the text will be paragraph form, if you wan them to be a vertical list as in excel then ctrl+t for edit text box to open and then paste in there.
the above works just gives the names in a single line not a list as in excel. you have to go and edit the single line to make a column
-
If you do happen to paste it into Corel and it is paragraph text hit Ctrl+F8 to convert it into Artistic text and you will be able to change fonts and font size without problems.
-
NOTEPAD....saves lives...I do it all the time, easiest way I have ever found. Copy from whatever program they used, paste to notepad, copy and paste that into Corel. Don't ask me why but it works.
-
NOTEPAD....saves lives...I do it all the time, easiest way I have ever found. Copy from whatever program they used, paste to notepad, copy and paste that into Corel. Don't ask me why but it works.
very simple much better than my way.
-
ctrl+t for edit text box to open and then paste in there.
This is what I do almost all the time.