Change value of cell on copy

[zgall1]

I have attached an Excel file.

In this file, the user fills out a column of data and the cell in the first row of the given column is populated with the data entered in the column (see cell C1 for an example).

Since the cell in the first row is a URL, all spaces must be entered as "%20" to ensure that the URL is valid. Is there any way to create a script such that the user could enter regular spaces when they are entering their data but the link in the first row would translate those spaces to "%20" when copied?

[xladept]

How about

StringName=Replace(StringName, " ","%20")

[zgall1]

Is that code that is intended to be inserted into a macro and run before every time a link is copied?

[xladept]

Yeah - the StringName represents the URL - just put it through that before finalizing the link

[zgall1]

Thanks for the help.

[xladept]

You're welcome and thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.