mohsandeep
New Member
- Joined
- Mar 18, 2012
- Messages
- 35
Hello,
Could you please help me remove "#" values from a text below:
"COUNTRIES W/O #" are the result I am expecting. Kindly suggest a formula to remove the ";#" values and the numbers and a ", " when there are two or more Countries.
<TBODY>
</TBODY>
Could you please help me remove "#" values from a text below:
"COUNTRIES W/O #" are the result I am expecting. Kindly suggest a formula to remove the ";#" values and the numbers and a ", " when there are two or more Countries.
Countries with # | Countries W/O # |
Finland;#73 | Finland |
Italy;#113 | Italy |
Austria;#14;#Germany;#60;#United Kingdom;#80;#Netherlands;#169 | Austria, Germany, United Kingdom, Netherlands |
Germany;#60;#United Kingdom;#80;#Netherlands;#169;#Austria;#14 | Germany, United Kingdom, Netherlands, Austria |
Netherlands;#169 | Netherlands |
<TBODY>
</TBODY>
Last edited: