Hey guys,
Is there a way to set all the cells on my sheet NOT to Wrap Text, when they are pasted into?
When cutting & pasting long addresses into cells I often have to manually turn of the Wrap Text option for each cell, as to stop the row height expanding massively.
Many thanks,
j
Is wrap text selected in the data you're copying and pasting from? Excel brings in formatting when you paste by default. If so, you can copy > paste special > value, and that won't bring in the wrap text formatting.
<--- If you like the answer, press *.
I am cutting & pasting addresses from the web.. presumable there is no formatting in this text?
I just dont understand why I cant set my whole sheet/workbook, not to wrap text regardless of what is pasted into it..
Do you have that issue every time you copy and paste data or only sometimes? Do you always copy & paste from the same site, or different sites? It is not always safe to assume no formatting on text if you didn't create it.
Once copied in to cells, you can remove all wrap cells by a macro code.
I assume..
Address means address.. not URL.. correct me if i am wrong..
and Address are like..
15, Blvd, California,
USA..
paste it in WORD, and check "Hide/Show Paragraph mark" you may found, there was Chr(10) is assosiated with it..
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Hi AB33:
Yours is a good suggestion. With event code:
Please Login or Register to view this content.
Gary's Student
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks