Replace special character

Hi ,

I have a date with serial number in column A and name in B. Names are prefixed with title like Mr. Mrs.

Is there any vba code to copy the entire B in same as in C and Remove all Title before the name.

The problem is that the Title is not in specific format. Some contains Caps, some are with space and double space and some are in Small


No. Name
1 Mr.HARRY (need Reault in C as "Harry")
2 mR.OLIVER
3 mr.JACK
4 Mr.ALFIE
5 MR.CHARLIE
6 MR.THOMAS
7 MR.JACOB
8 Mr. JAMES
9 mR. JOSHUA
10 mr. WILLIAM
11 Mr. ETHAN
12 MR. GEORGE
13 MR. RILEY
14 MR. DANIEL


See attachment for more examples.