Force pasted text to be "default" format?

[bythecshore]

I'm building a press contact list by visiting many, many websites and then copying & pasting the name, phone, email, etc. into Excel fields.

There are all kinds of formats when I paste into Excel which make the sheet a mess, so I have to continually fix the formatting by coping & pasting format from an existing cell that has the right format.

Is there a way to force any pasted text into this spreadsheet to be a particular foment, e.g., Helvetica 12 pt? It would really speed up my work.

 

[JoeMo]

Have you tried pasting as values?

 

[bythecshore]

Yes, that would work, but I'm trying to skip any intermediary step.

So the way it would work is, no matter what the format is on the clipboard, the receiving cell would convert it into the format I need, e.g., Helvetica 12 pt.

 

[JoeMo]

Yes, that would work, but I'm trying to skip any intermediary step.

So the way it would work is, no matter what the format is on the clipboard, the receiving cell would convert it into the format I need, e.g., Helvetica 12 pt.

That would require VBA code assigned to the worksheet that would make the format change automatically in cells that are pasted.