#### smozgur

##### BatCoder

- Joined
- Feb 28, 2002

- Messages
- 1,229

REVERSE function returns the contents of the given text with all the characters reversed.

Much better version provided by @Peter_SSs:

Excel Formula:

```
=LAMBDA(reference,
TEXTJOIN("",TRUE,MID(reference,SEQUENCE(LEN(reference),,LEN(reference),-1),1)))
```

Much better version provided by @Peter_SSs:

Excel Formula:

```
=LAMBDA(reference,
LET(L,LEN(reference),CONCAT(MID(reference,SEQUENCE(L,,L,-1),1))))
```

Book1 | ||||
---|---|---|---|---|

A | B | |||

1 | 123456789 | 987654321 | ||

Sheet1 |

Cell Formulas | ||
---|---|---|

Range | Formula | |

B1 | B1 | =REVERSE(A1) |

Last edited:

Upvote
0