Welcome toVigges Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others


0 votes
in Technique[技术] by (71.8m points)

excel - How to filter symmetric words from a column of data?

I have a list of words and I would like to find all symmetric words and some how put value 1 for each of them (see the picture).

enter image description here

Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

This does the trick:


It reads the string in a cell backwards using MID and SEQUENCE, and compares the CONCAT result with the original to see if it is the same, i.e. the string is symmetric.

Multiplying by 1 forces the Boolean into an integer.


Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share