How can i Find alphabet and space pattern in NAME

[Madhuri_G]

I have a data, which says the "NAME" and few of the columns have two initials, it should be changed..

1st scenario is
A L
B G
C A
U H
......... and so on (multiple initial with space combination)

2nd scenario is
AK
BH
CK
DE
JE
AND so on.........(multiple INITAILS combination)

I need to find these two patterns and chnage it to certain text format... as "Supporter"

I need to know the formula in excel guys any help??

 

[salim hasan]

Suppose that your data is in column A from A1 to A20
use this code

Option Explicit
Sub TEST()
Dim I%
    For I = 1 To 20
        If Cells(I, 1) Like "[A-Za-z| ]*" Then
        Cells(I, 2) = "OK"
        End If
     Next
 End Sub

 

[Madhuri_G]

I need the excel formula guys?

 

[Madhuri_G]

Hi Freinds,

Please check the AFTER & Before formula in Excel, I need FULLSALUTATION formula, it should return "Supporter" if column F is FALSE and has a SEGMENT accociated to it.

For dots(anamolies), one initial, two initials - it must return "Supporter". Any quick help is appreciated guys... Pls

 

[bosco_yip]

Hi Freinds,

Please check the AFTER & Before formula in Excel, I need FULLSALUTATION formula, it should return "Supporter" if column F is FALSE and has a SEGMENT accociated to it.

For dots(anamolies), one initial, two initials - it must return "Supporter". Any quick help is appreciated guys... Pls

Duplicated-post

Don't open a new post for the same question, and please follow your original post in :

https://chandoo.org/forum/threads/need-help-in-excel-formula-to-address-fullsalutation.39934/

Post closed

Regards
Bosco