←Back to all posts
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Create a mixed column pattern in excel

Hi,

I have this: 1,2,3,4,5,6,7,8,9...n in columns (A1) : (An) respectively

I want a FORMULA (not a copy/cut/paste solution) that can return this: 1,2,3,TEXT,4,5,6,TEXT,7,8,9,TEXT, etc.

Any help is much appreciated!

submitted by /u/Silent_Storage8564
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article→