|
| 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
January 8th, 2006, 11:03 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
How to make one column be the result of an equation between two
I have a blank column which I want to fill with the results of a concatenation between two other columns...could someone give me the general steps on how to do this (doesn't have to be concatenation operation, could also be a sum between values of columns, for example). -- dcnguyen ------------------------------------------------------------------------ dcnguyen's Profile: http://www.excelforum.com/member.php...o&userid=30251 View this thread: http://www.excelforum.com/showthread...hreadid=499221 
|
|
#2
January 8th, 2006, 11:13 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to make one column be the result of an equation between two
Hi
Assuming the columns with values are A and B and the blank column to receive the results is C. For concatenation, in C1 =A1&B1 or with a space between =A1&" "&B1 For addition =A1+B1 -- Regards Roger Govier "dcnguyen" wrote in message ... I have a blank column which I want to fill with the results of a concatenation between two other columns...could someone give me the general steps on how to do this (doesn't have to be concatenation operation, could also be a sum between values of columns, for example). -- dcnguyen ------------------------------------------------------------------------ dcnguyen's Profile: http://www.excelforum.com/member.php...o&userid=30251 View this thread: http://www.excelforum.com/showthread...hreadid=499221
|
|
#3
January 8th, 2006, 11:29 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to make one column be the result of an equation between two
Thanks for the response...two things... I'm typing that in the cell (=A1&B1) and all I'm getting is a exactly that..."=A1&B1" And what I have is a datasheet with several thousand rows...how do I make the operation apply to the entire columns? Roger Govier Wrote: Hi Assuming the columns with values are A and B and the blank column to receive the results is C. For concatenation, in C1 =A1&B1 or with a space between =A1&" "&B1 For addition =A1+B1 -- Regards Roger Govier "dcnguyen" wrote in message ... I have a blank column which I want to fill with the results of a concatenation between two other columns...could someone give me the general steps on how to do this (doesn't have to be concatenation operation, could also be a sum between values of columns, for example). -- dcnguyen ------------------------------------------------------------------------ dcnguyen's Profile: http://www.excelforum.com/member.php...o&userid=30251 View this thread: http://www.excelforum.com/showthread...hreadid=499221 -- dcnguyen ------------------------------------------------------------------------ dcnguyen's Profile: http://www.excelforum.com/member.php...o&userid=30251 View this thread: http://www.excelforum.com/showthread...hreadid=499221
|
|
#4
January 8th, 2006, 11:41 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to make one column be the result of an equation between two
Hi
Don't put brackets around the equation. Just =A1&B1 Copy the formula and paste it down through the remaining cells in column C. The formula will later automatically as it is copied to each successive cell e,g, =A2&C2 =A3&C3 The easiest way to fill the cells going down is to use the fill handle. Hover your cursor over the bottom left corner of cell C1 when you have the formula correctly entered, and it will change to a small black cross. Either double click the cursor at this point and it should fill down, or, hold the left mouse button down as you drag down the column. When you release the mouse button, the formula will be copied to the range of cells marked. -- Regards Roger Govier "dcnguyen" wrote in message ... Thanks for the response...two things... I'm typing that in the cell (=A1&B1) and all I'm getting is a exactly that..."=A1&B1" And what I have is a datasheet with several thousand rows...how do I make the operation apply to the entire columns? Roger Govier Wrote: Hi Assuming the columns with values are A and B and the blank column to receive the results is C. For concatenation, in C1 =A1&B1 or with a space between =A1&" "&B1 For addition =A1+B1 -- Regards Roger Govier "dcnguyen" wrote in message ... I have a blank column which I want to fill with the results of a concatenation between two other columns...could someone give me the general steps on how to do this (doesn't have to be concatenation operation, could also be a sum between values of columns, for example). -- dcnguyen ------------------------------------------------------------------------ dcnguyen's Profile: http://www.excelforum.com/member.php...o&userid=30251 View this thread: http://www.excelforum.com/showthread...hreadid=499221 -- dcnguyen ------------------------------------------------------------------------ dcnguyen's Profile: http://www.excelforum.com/member.php...o&userid=30251 View this thread: http://www.excelforum.com/showthread...hreadid=499221
|
|
#5
January 8th, 2006, 11:52 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to make one column be the result of an equation between two
OK, that's what I meant...I didn't put brackets in the cell...all I did was enter into C1: =A1&B1 And that's all that shows in the cell...do I just have a setting off or something? -- dcnguyen ------------------------------------------------------------------------ dcnguyen's Profile: http://www.excelforum.com/member.php...o&userid=30251 View this thread: http://www.excelforum.com/showthread...hreadid=499221
|
|
#6
January 8th, 2006, 11:58 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to make one column be the result of an equation between two
Hi
Your cell must have been formatted as Text. FormatCellsNumberGeneral Enter formula Press Enter -- Regards Roger Govier "dcnguyen" wrote in message ... OK, that's what I meant...I didn't put brackets in the cell...all I did was enter into C1: =A1&B1 And that's all that shows in the cell...do I just have a setting off or something? -- dcnguyen ------------------------------------------------------------------------ dcnguyen's Profile: http://www.excelforum.com/member.php...o&userid=30251 View this thread: http://www.excelforum.com/showthread...hreadid=499221
|
|
#7
January 9th, 2006, 12:22 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to make one column be the result of an equation between two
Ah... I've done this kind of thing before, I knew it was some stupid little thing like that. -- dcnguyen ------------------------------------------------------------------------ dcnguyen's Profile: http://www.excelforum.com/member.php...o&userid=30251 View this thread: http://www.excelforum.com/showthread...hreadid=499221
|
|
#8
January 9th, 2006, 12:28 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to make one column be the result of an equation between two
Hi
Its always the little things that catch us out. glad you got it sorted. Thanks for letting us know. -- Regards Roger Govier "dcnguyen" wrote in message ... Ah... I've done this kind of thing before, I knew it was some stupid little thing like that. -- dcnguyen ------------------------------------------------------------------------ dcnguyen's Profile: http://www.excelforum.com/member.php...o&userid=30251 View this thread: http://www.excelforum.com/showthread...hreadid=499221
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Positioning Numeric Values Resulting from 6 Column Array Formula | Sam via OfficeKB.com | Worksheet Functions | 2 | January 5th, 2006 02:03 AM |
| PLEASE HELP with the SPELLNUMBER function | vag | Worksheet Functions | 0 | June 16th, 2005 01:33 PM |
| EXCEL:NUMBER TO GREEK WORDS | vag | Worksheet Functions | 1 | June 15th, 2005 05:57 PM |
| Find value in column and associate result to it | Eduardo | General Discussion | 1 | June 17th, 2004 03:12 PM |
| Can I make a formula that has the result of "0" remain empty? | DangerMouse114 | Worksheet Functions | 2 | May 12th, 2004 06:00 AM |
Linear Mode
