Shift cells from right to left side

Question

For automation purposes, I want to reflect the cells from right side to left side from the active cell.

Example: In H2 cell ={"A","B","C"}. This result will spill in H2, I2, J2 cells like (A, B, C) .

I am looking for the solution would be in cells F2, G2, H2, i.e. (C, B, A) from H2 cell.

How can I do this with Excel formulas?

You cannot have both your source and your results in the same cell, so no, you cannot do this with formulas. — Ron Rosenfeld
– Ron Rosenfeld, Commented Oct 26 at 8:45
I believe this always works from left to work, not the other way around. Why do you want to do this? (Maybe this is an XY-problem.) — Dominique
– Dominique, Commented Oct 31 at 8:03

MGonet · Accepted Answer · 2025-10-26 10:33:28Z

0

It is not possible to get result in the same row, but if we place the result in row 3, for example, then in A3 we can put the following formula:
=LET(wd,COLUMNS(A:H),SORTBY(EXPAND($H$2#,,wd,""),SEQUENCE(,wd),-1))
Alternatively, if you do not place the constant {"A","B","C"} in a worksheet cell, but directly in the formula, then the result can be in any row.
=LET(wd,COLUMNS(A:H),SORTBY(EXPAND({"A","B","C"},,wd,""),SEQUENCE(,wd),-1))

edited Oct 26 at 10:33

answered Oct 26 at 10:24

MGonet

2,6952 gold badges3 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Harun24hr Oct 26 at 10:26

OP wants to put formula in H2 cell then spill the result to left direction H2-->G2-->F2.

MGonet Oct 26 at 10:40

Spilling to the left is not possible unless we change the way the sheet is displayed to right to left, but it will still be columns H, I, J, not H, G, F.

Harun24hr Oct 26 at 10:57

Yes, so not possible.

MGonet Oct 26 at 11:23

Agreed, I just think that if the solution conceived by the OP is not possible, then it is worth giving a similar solution.

Collectives™ on Stack Overflow

Shift cells from right to left side

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related