i am looking for the raw text of a url to be input into a subsequent formula. Excel must be wrapping www.ibm.com wtih special characters i dont see (because it displays just the text, but i am guessing Excel puts HTTP:// infront or does something else. how do i get w w w . i b m . c o m (just the text, nothing else).
Solved by E. S. in 16 mins