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.

will do.

is there any vba. because i have more than 3 lakhs name in multiple sheets

perfect. Thank you. thanks a ton

hey is there any solution if there is no "."
if data is like below

M r HARRY
m r OLIVER
m r JACK
M r ALFIE
M r CHARLIE
M r THOMAS
M r JACOB
M r JAMES
m r JOSHUA
m r WILLIAM
M r ETHAN
M r GEORGE
M r RILEY
M r DANIEL
M r SAMUEL
m r NOAH
m r OSCAR
M r JOSEPH
M r MOHAMMED
M r MAX
M r DYLAN
M S Aaliyah
M S Aamanda
M S Aamani
M S Bailee
M S Baileigh
M S Bailey
M rS Eadda
M rs Eadmund
M rs Eadwine
m rs Edelburga
m rS Edeline
m rS Edeva
M S Edie
M S Gabbriel
M S Gabbriella
M S Gabby
M S Gabi
M S Gabrielle
M rS Gella
M rs Gemelle
M rs Gena
m rs Genee
m rS Genesiss
m rS Gabbriel
M S Jessica
M S Georgia
M S Emma
M S Olivia
M S Hannah
M S Grace
M rS Sarah
M rs Sophie
M rs Samantha
m rs Emily
m rS Caitlin
m rS Ella
M S Tayla
M S Brooke
M S Rebecca
M S Shania
M S Courtney
M S Kate
M rS Madison
M rs Charlotte
M rs Lucy
m rs Paige
m rS Jade
m rS Charlotte
M S Jamie
M S Sophia
M S Maia
M S Molly
M S Casey
M S Maria
M rS Rebekah
M rs Jessie
M rs Gabrielle
m rs Michelle
m rS Morgan
m rS Angel
M S Tegan
M S Tiana
M S Caitlyn
M S Renee
M S Julia
M S Madeleine
M rS Summer
M rs Kaitlyn
M rs Kelsey
m rs Tessa
m rS Alicia
m rS Jamie

Hey Shg,

I am waiting for your reply. Can you please help

Please Login or Register  to view this content.