Is it possible

[Help on formula]

Hi,
I have two columns of names A and B (A=First name B=Last name). My question
is, without changing the column A and B, how could be the Macro defined so
that column A’s or B’s characters are if less than four, the comas (,)
inserts into to make it four i.e. “Leo=LEO,†“A=A,,,â€. Blank fields should
stay blank and if it’s possible if the small letters of name in column A or B
can also be capitalized in the same Macro. To explore the possibilities I
thanks in advance…

Sincerely Shan

 

[Jim Thomlinson]

Something like this should do...
=IF(LEN(A1) = 0, "", IF(LEN(A1)>= 4, UPPER(A1), UPPER(A1) & REPT(",",
4-LEN(A1))))

 

[Help on formula]

Thank you very much for your response. I am trying to avoid creating
additional column/s because the data will be inserted in fields by copy past
process (source to destination). For example the source fields are A B C D
and E (First Name, Last Name, Address, City and State) which will be pasted
into destination fields of A B C D and E columns, if the destination fields
are different than the source it won't work. Please help to resolve it by
Marco to be defined in one of the row in destination file. Thank you very much
Sincerely Shan

 

[Help on formula]

I think it’s almost done, the only thing is a syntax error which I unable to
find built-in help to correct it, I know it's probably me. Please help me to
correct it I will be much appreciated.

If Len(cll.Value) < 4 And cll.Value <> "" Then cll.Value =
Left(cll.Value & ",,,,", 4)

 

[Help on formula]

Thank you very much from the bottom my hart! It works. I wish if the names
could also be the capitalized. Please..

 

[Help on formula]

Oh, never mind it does all. I can't believe it!
I thank very much, what a Good Man you are!

Thank you very much from the bottom my hart! It works. I wish if the names
could also be the capitalized. Please..