|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 22nd, 2004, 02:44 AM
|
|||
|
|||
combining columns
one85x In c2 enter this formula =right("b2",4) & left("a2",1) -- mudraker ------------------------------------------------------------------------ mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473 View this thread: http://www.excelforum.com/showthread...hreadid=271384 
|
|
#2
October 23rd, 2004, 06:18 AM
|
|||
|
|||
|
I don't think you have to enclose the cells in quotes. So. modifying the formula a little bit, it should look something like =right(B2,4)&left(A2,1) mudraker Wrote: one85x In c2 enter this formula =right("b2",4) & left("a2",1) -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=271384
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Menu Bar Security and UNHIDING columns | AccessNana | General Discussion | 1 | August 29th, 2004 02:33 PM |
| combining columns | JOEBRANT | New Users | 4 | June 3rd, 2004 04:15 AM |
| comparing data and return only data that exsist in the 2 columns | victorwill | Worksheet Functions | 2 | December 27th, 2003 12:13 AM |
| Adding rows in two dynamic columns | Justin Etheredge | Worksheet Functions | 0 | November 24th, 2003 10:27 PM |
Linear Mode
