I never Excelled in Excel
May 13, 2008 2:32 PM Subscribe
I have no clue what I am doing in Excel, so this is going to be a bit hard to explain, but hopefully somebody can help me here. I want to give Excel some text, and have it output a string. Let me explain.
posted by B(oYo)BIES to computers & internet (4 answers total)
I type in something like
I would like to see
- stays - | ^ is changed to %5E | “ is changed to %22 | (space) is changed to +
I would continue in the same fashion down column A. The next thing I would like to do is take C1
(which is www.someaddress.com/q=) and add all the B column and then C2
(which is &something) and put the results in C3
My output should be something like www.someaddress.com/q=-%5E%22some+text%22+-%5E%22some+other+text%22+&something
So, can anybody explain how to do this to an Excel dummy? 2007, if it matters.