Reversing Data
Can you reverse the data in two different columns? If I have the
following column of numbers... 64 32 21 23 56 82 23 24 12 1 I want to reverse the data in the second group so it reads: 12 32 65 82 32 Is there an easy way to do that all at once? Thanks |
Reversing Data
you could use a user defined function. paste the code into a vba module
Function RevText(strText As String) As String RevText = StrReverse(strText) End Function and use it like any other XL function =RevText(A4) and copy it down. to coerce the return value from text back to numeric use =--RevText(A4) if you are new to vba, david mcritchie has some tutorials on his site to help you navigate the vba editor. http://www.mvps.org/dmcritchie/excel/excel.htm "Peter" wrote: Can you reverse the data in two different columns? If I have the following column of numbers... 64 32 21 23 56 82 23 24 12 1 I want to reverse the data in the second group so it reads: 12 32 65 82 32 Is there an easy way to do that all at once? Thanks |
All times are GMT +1. The time now is 04:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com