LinkBack URL
About LinkBacks
that changes the case of the letters and the case up the letters is critical for other calculations. So I didnt see anyhting about alphabetizing them. This is an example of the result: zA aB tm. I would like to have it say Az aB mt
that changes the case of the letters and the case up the letters is critical for other calculations. So I didnt see anyhting about alphabetizing them. This is an example of the result: zA aB tm. I would like to have it say Az aB mt
Proper case will change text like zA aB to Za Ab
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Originally Posted by VBA Noob
I think the OP means to rearrange the resulting characters in alphabetic order
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
yup exactally what I mean. but still stay in there original two
Your example shows 2 proper case and one Lower so try
Amend as required=PROPER(LEFT($E8,1)&LEFT(G5,1))&" "&PROPER(MID($E8,2,1)&MID(G5,2,1))&" "&RIGHT($E8,1)&RIGHT(G5,1)
VBA Noob
the problem is the letter combination will allways be different. Here's my program after selecting the Morph and variation of the parents you'll see the squares that are formulated. I think its like F6:M11
Two points
Firstly.
Not everyone has xl 2007 so you won't get much help
Secondly.
If you upload an example you should populate the cells and show the expected results
VBA Noob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks