200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I am using an excel worksheet for my Qaballistic endeavors. I have one column dedicated to text in which I use the "concatenate" formula in excel. In another column, I have the numeric definition for the text (see greek gematria for basic understanding of assigning numeric values to letters). When I attempt to sort the number column, I lose all the concatenation from the text column. Are you aware of any type of macros that can solve this for me?
Thanks,
William M. Hollingsworth
If all your concatenations are within the same row you must ensure that all columns of your used range are included in the sort. If you sort only one column, of course, the other columns remain in place and references get lost. If this doesn't work for you for whatever reason (for example because you reference another worksheet or other rows in the same worksheet), a solution won't be possible without looking at your worksheet and the exact steps by which you sort it.
