•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Wanting to Combine a Shared Prefix and Suffix Onto a Number
I am trying to make a sheet where I can type a set prefix into a designated cell, a set suffix into a designated cell, and have that sandwiched around a list of numbers that will increase by five every time.
For example: prefix is "X" suffix is "Y"
I want it to look like X15Y, X20Y, all the way to X150Y. Preferably descending so I can hit enter to move down a cell.
Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#real-time data collaboration
#prefix
#suffix
#numbers
#increase by five
#Excel
#designated cell
#descending
#sheet
#cell
#sandwiched
#X15Y
#X20Y
#X150Y
#set prefix