I am working on a halfscale replica of the Vietnam Memorial Wall. My client has provided me with an excel file of all 58,260 names of fallen soldiers. The font for the names is Optima, and after each name, the font "Symbol" is used to display a diamond shape, and in few instances a plus symbol.
I NEED to get the text from Excel into AI CS4. I am running Vista (ugh). So far, I select all the text and copy from excel. Then I select the Type Tool and paste onto the AI file. That's when the font substitution occurs.
I've noticed that whatever font I have selected at the top is the one it will substitute. But my problem is, I need it to maintain two different fonts. I have also tried the various "paste special" options.
Obviously, it will be a very long process if I have to change every diamond by hand. I have also tried pasting the text into Corel X3 on a whim, and Microsoft word first. I need this to remain in a vector format because it will be engraved.