•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
TRIMRANGE, dot operator, or other?
What is the best way to apply formulas in column C that simply concatenates all of the data in columns A and B, but expands if columns A and B go from 50 rows to say 60 rows with new data so you don’t have to drag down formulas? I have headers in row 1. I’ve been using in C2: =DROP((A:.A&B:.B),1). Now with TRIMRANGE, I can do =DROP(TRIMRANGE(A:A)&TRIMRANGE(B:B),1). However that seems no better with this newer function, and if anything a lengthier formula. What’s the best way to do this?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#AI formula generation techniques
#Excel compatibility
#row zero
#formula generator
#Excel alternatives
#TRIMRANGE
#formulas