Hi
I want to proper case "ala'a" as "Ala'a" but I get "Ala'A"
I want to make first letter of every word if it is separated by space and not by a non alpha character
Thanks in advance
Imran Bhatti
Hi
I want to proper case "ala'a" as "Ala'a" but I get "Ala'A"
I want to make first letter of every word if it is separated by space and not by a non alpha character
Thanks in advance
Imran Bhatti
Teach me Excel VBA
This ..???
=UPPER(LEFT(A1))&MID(A1,2,255)
Thinking...
Last edited by Special-K; 12-21-2017 at 07:37 AM.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Try
Formula:=SUBSTITUTE(PROPER(A1),"'A","'a")
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
This name is a variable.Can hard code the parts
@than
It also not helped
give some more examples..
upper case.PNG
@than
I need proper case means capitaling every words's first letter . Your formula not capitaliizng
Try this one:
Formula:=REPLACE(LOWER(C2),1,1,UPPER(LEFT(C2,1)))
Supply a REASONABLE amount of test data or you will end up with it not working.
One piece of data is not a reasonable amount.
Hi Forum signing off for two hours from the office will be online from home.
Assuming words are delimited by blank
=Ufirst(A1)Function Ufirst(Lstring As String) As String Dim Larray() As String Larray = Split(Lstring) Ufirst = "" For i = 0 To UBound(Larray()) Ufirst = Ufirst & UCase(Left(Larray(i), 1)) & Mid(Larray(i), 2, 255) & " " Next i Ufirst = Trim(Ufirst) End Function
Try something like,
Substitute ' with ß, use Proper. Then substitute ß with '=SUBSTITUTE(PROPER(SUBSTITUTE(A1,"'","ß")),"ß","'")
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Sample attached. A column is original text while B column is desired
Yes Special-K there were two typos.
Both the VBA way of John and Formula way of Haseeb are working now. Thanks all of you for the precious time.
Thank you & add reputation please...
Yes I will add reputation despite they all are beyond repute.
And here I must attache the file with both the solution applied so that the researchers may have a ready made solution file on the web.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks