Related Posts
Bowl Leader
Welcome to the LTIMindtree
Bain & Company Which are the best consulting firms and practices for Climate Change & Sustainability, especially in the Canadian geography? Also, please suggest the best Canadian city for consulting jobs.
McKinsey & Company | Boston Consulting Group | Bain & Company | Kearney | LEK | EY | Oliver Wyman | PwC | Deloitte
#ClimateChange #Sustainability #Water #ESG
Bowl Leader
What NFT wallet do you all use?
Pro
Additional Posts in Excel Genius
Coach
Visual Storyteller
Anyone know what these badges are?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
A simple Formula you could use is also =A1 & “ “ & A2 which will combine cell values and include a space between them.
Subject Expert
Well, not sure if I'm missing smth, but your example and your question have different requests (or at least appears to me)
Nonetheless, if you want to combine two cells into a single cell:
=TEXTJOIN(delimiter,TRUE,range);
Where delimiter is the separator between the text (example: use " " for space), the TRUE means (ignore blank cells), and the range is the range of cells you want to concatenate
Other alternatives include CONCAT and using ampersand, but they have limitations
Subject Expert
Tbh no - can you share a screenshot (with dummy data)
Thank you!!! This is it
Example:
Cell A1 - hello
Cell A2 - thank you
Cell A3 - hello
Thank you
Or =CONCATENATE ()
Came here to say this. Just used concat to do exactly this just the other day
So you can start a new line within a cell using Alt + Enter but I’m not aware of any formula that can do this with two cells automatically. Same as the other comments I would suggest doing =CONCATENATE(A1,” “,A2) and then trying Wrap Text for the output column
Test comment
Have you tried using named ranges? For example you could give the two cells you want to combine the range name of "RANGE" and then enter the formula =RANGE into the cell. Im genuinely curious if that would work. I haven't tested that theory. I logged in to post a question of my own haha.
Then you test it😁