Jan 3, 2017 · Function opposite to CONCATENATE? I have a large spreadsheet that shows the date and time in one cell. I would like to separate the date from the time into two cells. I am familiar with …

Jun 21, 2004 · I know how to use the concatenate function, but if I have the opposite issue - i.e. lots of text (comma separated) is there a function which will allow me to separate this into different colums …

Nov 26, 2014 · I have discovered the useful CONCATENATE function, which I have typically been using to combine 2 cells with surname (b1) and first name (a1). eg. =CONCATENATE(B1, ", ", A1) returns …

Oct 4, 2006 · Although I am here for assistance for my own question about concatenate (and rank function), I can answer that question somewhat. In Excel 2007, the opposite would be in Data ribbon, …

May 17, 2004 · Can I do some sort of un-concatenate? For example, if I have the following text in cell A1: June, August And I want to change it so that I have June in cell A2 and August in cell A3, is there …

Jul 26, 2002 · Similar threads 1 Concatenate multiple cells based on cells above if Istext 1021557 Aug 7, 2025 Excel Questions Replies 3 Views 153 Aug 7, 2025

May 1, 2008 · Hi, I have data in the format surname, forename for a large amount of people. I need to be able to split the cell into two seperate cells, one for forename and one for surname. Can you do …

Jun 23, 2004 · For example, if the entry is, say, 23B, I want to separate the 23 and B, and have Excel automatically put them in separate columns. Can anyone think of a useful and efficient formula, that …

Nov 30, 2005 · CptTightPants Jul 23, 2025 Excel Questions Replies 5 Views 464 Jul 24, 2025 CptTightPants C Formula Sum From D2: to last column -1 drom Jun 1, 2025 Excel Questions …

Feb 27, 2002 · If VIN numbers are fixed length you can use the Data | Text to Columns... menu command. BTW, the "opposite of concatenation" is called parsing. This message was edited by Mark …