How can I reverse the data in row for example : I enter the data
(1,2,3,4,5) and I want it in (5,4,3,2,1) in the same row :rolleyes:

Can you upload a sample sheet showing before and after? Be sure to show the data the same way you're going to want to show it in your real sheet. Putting the example data into the same cells/columns/rows will also make it easier to "adapt" the solution I may offer.

Click on GO ADVANCED and use the paperclip icon to attach a workbook.