ExcelBanter - I need to rearrange the information in a column. Help?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I need to rearrange the information in a column. Help? (https://www.excelbanter.com/excel-discussion-misc-queries/222437-re-i-need-rearrange-information-column-help.html)

curlydave

I need to rearrange the information in a column. Help?

On Feb 26, 12:47*pm, lbrown wrote:
I need to sort the data in the column by the last few digits in the column
and not the first few. Is this possible?

You could use a helper column, in column B use this formula and copy
it down
=RIGHT(A2,3)*1
The select A1 and go to data=sort and sort by column B

All times are GMT +1. The time now is 07:50 AM.