2017年1月3日 · 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-08:00 I would like to split it into two cells: 1) 2017-01-03 and 2) 08:10:37-08:00.

2014年11月26日 · 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 in "Smith, John" where cell A1 contained "John" and B1 contained "Smith". My question is whether there is a...

2006年10月4日 · 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, Data Tools group, and selecting "Text to Columns". This will separate data into different columns. Is that what you are looking for? Regards, * CalvinTy

2008年5月1日 · 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 the opposite of concatenate and split the data out. Thanks Stewart

2007年3月26日 · Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

2009年6月8日 · 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; 32;Derek; And I need to split it into two fields: Percent 31.1 29 59.6 32 Name Steve Mike Rick Derek Note that ";" is a delimiter.

2004年5月17日 · 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 a function to do that? The comma placement is consistent in all of my data. Thanks! P.S. I'm using 2007 - not sure if that matters.

2015年11月4日 · 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 .....etc What I am trying to do is the opposite of the CONCATENATE function. Ken

2009年6月25日 · 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 little more. I have a column which I use in a larger spreadsheet which reads something like this: 10*3 I …

2004年6月21日 · 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 Search forums Board Rules