LPW 21: Last Poser Wins

[Nicholas]

How do I prevent Excel from formatting whatever I paste into it as a hyperlink? [I'm pasting as Text.]

 

[spiderz]

Sadly

oh well, then i'll have to go have a beer without you ...

 

[spiderz]

Maybe something more entrepreneurial such Evil Overlord?

Well, he did start as a slave driver for the Pharaoh's

 

[satanboy]

Maybe something more entrepreneurial such Evil Overlord?

I would be excellent at it. What does it pay?

 

[satanboy]

How do I prevent Excel from formatting whatever I paste into it as a hyperlink? [I'm pasting as Text.]

1. Paste Special
2. Text

 

[spiderz]

How do I prevent Excel from formatting whatever I paste into it as a hyperlink? [I'm pasting as Text.]

Paste it in a note pad first. or paste it into the top edit box for the field.

or Just Format ... Install Linux!

 

[Nicholas]

I am capturing the same tender for every administrative district in the Eastern Cape. Each has a different list of contact people, reference number, due date, and delivery address.

 

[Tribs]

No @satanboy is correct - you can make it permanent by changing you past settings under options

 

[Nicholas]

Well, he did start as a slave driver for the Pharaoh's

Are you sure that they used slave labour?

 

[Nicholas]

I would be excellent at it. What does it pay?

Millions or billions of credits - it depends on ow much work you put into it.

 

[Nicholas]

1. Paste Special
2. Text

That's what I am doing.

 

[Nicholas]

Paste it in a note pad first. or paste it into the top edit box for the field.

or Just Format ... Install Linux!

Notepad may work.

Install Linux......

 

[dabean]

How do I prevent Excel from formatting whatever I paste into it as a hyperlink? [I'm pasting as Text.]

 

[Quetzalovercoatl]

/Jedi wave

This is not the solution for excel that you are looking for

/Jedi wave

 

[Quetzalovercoatl]

Awww buggrit, mah iced zoo biccies est finito! :cries:

 

[Tribs]

Awww buggrit, mah iced zoo biccies est finito! :cries:

That is sad. Hate when that happens

 

[BloodrayneZA]

How do I prevent Excel from formatting whatever I paste into it as a hyperlink? [I'm pasting as Text.]

Use notepad to remove all formatting as when it’s pasted, it becomes plain text then copy n paste from notepad. I do it a lot.
Then there’s the option of the T backslash icon which also removes formatting ironically .

 

[Tribs]

Use notepad to remove all formatting as when it’s pasted, it becomes plain text then copy n paste from notepad. I do it a lot.
Then there’s the option of the T backslash icon which also removes formatting ironically .

No if it is an email for web format - it will paste and be converted. @dabean was correct in what should be done if you don't want that happening - or past as Text as @satanboy said

 

[satanboy]

Where was email mentioned?

 

[Nicholas]

View attachment 10706

Thank you. I'll try that.