• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract Letter

A

Anirban

New Member
Hi Chandoo,

I have 5000 data in a excel file like the below

CN=?*Anir?ban D?ebna#th,oum=h1h18375j435
CN=?*Rah?ul C?hatt#erjeem=h1h18375j435

I want to extract the names(highlighted in blue) from the entire string. I am able to do it for few with MID function but the problem is, pattern of the string is not similar for all. Need one formulae which can extract the name from all cells.

Thank you
Anirban
 
Hi Anirban ,

Will all the names be prefixed with the characters ?* ?

How do we recognize that the name is completed ? In the first example , the name is followed by a comma , but in the second it is followed by the letter m ; how can we understand that the name is completed ?

Narayan
 
We have names like this only, as i am familiar with the names i know that the highlighted selection is the complete name, rest are unwanted stuffs. We have also few names like

Ani?rban Debnath
Joh?n Po?well
Peter?Parker
Bruce Wa?ne

from where we need to remove the "?" and also let me know if i have to replace the "?" with a letter or a " " or vice versa what to do?
 
Last edited:
Anirban

You might not get what Narayan asked for!

How will we/XL recognized that name is completed & flush the remaining.

Removing "?" is not a big issue.

Can we have some more full strings to understand the logic of names.
 
Last edited:
I am sorry Deepak/Narayan that as of now i do not have more details, but now need your help to remove the "?" from the below names

Ani?rban Debnath
Joh?n Po?well
Peter?Parker
Bruce Wa?ne

and also if i have to replace the "?" with a letter or a " " or vice versa what to do?
 
You must log in or register to reply here.
Back
Top