Remove numbers from text and add new line to separate two strings based on delimiter in a cell

[devaprakash]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Actual[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]london#123;new york#34;[/TD]
[TD]london;
new york;[/TD]
[/TR]
[TR]
[TD]delhi#145;chennai#54;[/TD]
[TD]delhi;
chennai;[/TD]
[/TR]
[TR]
[TD]hyderabad#748;[/TD]
[TD]hyderabad;[/TD]
[/TR]
[TR]
[TD]Mumbai#456;Pune#234;Kerala#120;[/TD]
[TD]Mumbai;
Pune;
Kerala;[/TD]
[/TR]
</tbody>[/TABLE]


Hello All,

Can you please help me in removing the # and numbers from text and add new line after ; symbol.
So it would save me a lot of time in preparing status.


Thanks in advance.

 

[Rick Rothstein]

Runtime Error:13
Type Mismatch

That is the error itself... I need to know what line of my code produced that error. When the error occurred, one of my code lines should have been highlighted... post which line of code it is.