ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Changing a specific character type in text string (https://www.excelbanter.com/excel-discussion-misc-queries/18470-re-changing-specific-character-type-text-string.html)

olasa

Changing a specific character type in text string
 

Find and Replace (Ctrl+H):
Search for " " and replace with "%20". But exclude the " signs.

Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=355924



All times are GMT +1. The time now is 12:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com