Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by EvolBob
-
Reverse order of data in a cell
You could also use an array entered formula: =RIGHT(B2,MATCH(",",MID(B2,LEN(B2)-ROW(INDIRECT("1:"&LEN(B2))),1),0))&","&MID(B2,FIND(",",B2)+1,FIND(",",B2,FIND(",",B2)+1)-FIND(",",B2))&LEFT(B2,FIND(",",B2)-1) Here the text to reverse is in cell B2, and you enter the formula with the (Control +...- EvolBob
- Post #4
- Forum: Microsoft VBA - Visual Basic for Applications
