Jan 3, 2017 · I am familiar with the CONCATENATE function, and what I need would do the opposite. This is an example of what the contents of the cell contains: 2017-01-03T08:10:37 …

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, ", ", …

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 …

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. …

Mar 26, 2007 · Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Jun 8, 2009 · What is the opposite of concatenate when you are dealing with a table in Access? I have a table in Access 2000 with the following field: Detail 31.1;Steve; 29;Mike; 59.6;Rick; …

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 …

Nov 4, 2015 · Hi, If I have something like this in say cell Z1 0001234smith00x23435600abc Is there any way that I can put the first 5 characters in cell A1 the next 7 in B1 the next 4 in C1 …

Jun 25, 2009 · Hello everyone, hope there is an answer for my question. I am using Excel 2010 and I know there is a formula that does the opposite of the Concatenate formula, but I need a …

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... Forums New posts …