Mar 6, 2003 · Reverse Concatenating I use this method for single instances of reverse concatenating. It's no good for long term use but works well when dealing with a single instance or when you need a …

Oct 15, 2002 · If cell A1 contains "1" and Cell B1 contains "2", I can concatenate these two values to show "12" in Cell C1 by the formula =CONCATENATE (A1+B1). I am looking for the reverse of it.

Oct 21, 2015 · I am trying to do a reverse Concatenate in Excel for Address, many of them do not have a space between the street and Suite #, 8350 N Central ExpresswaySuite M1025 And I want to …

Oct 16, 2003 · Is there an easy way to split the data in a cell into two cells? I have one cell with First and Last name. I'd like to have two cells, one with First Name and one with Last Name. The first and last …

Mar 26, 2002 · Live Online Excel Training for Your Team from MrExcel. Bring MrExcel to your people. Two hours. High-impact. Zero travel. Click here for details.

Oct 13, 2011 · I tried searching for this in Excel's built-in Help but I just didn't know what to search on. The closest thing I found was help on Concatenate which doesn't do what I wanted.

Apr 7, 2002 · You could use some code, but the easiest way would be to use DATA>TEXT TO COLUMNS to parse the data into separate coulmns then use Concatenate to rejoin it in the reverse …

Jan 14, 2015 · Similar threads C Help Request - Using A Wildcard To Return A Specific Value As Part of A Concatenate Formula Chapter 13 May 4, 2025 Excel Questions Replies 7 Views 229 May 4, 2025

Jun 25, 2010 · Similar threads 1 Concatenate multiple cells based on cells above if Istext 1021557 Aug 7, 2025 Excel Questions Replies 3 Views 148 Aug 7, 2025

Dec 11, 2002 · HI! How do I do the opposite of what the function CONCATENATE does i.e. get two or more text strings to diffent cells. Example: first last=A1 and I need...