| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Combine two cells (numbers) but not add
I have column A of cells containing three digit numbers in each cell.
In column B, I have the same thing cells with three digit numbers. I would like to combine these two numbers into a six digit number. How can this be done? Also, in column B there are several cells with a zero value, so a blank is displayed. How can I make the zero values into three digits or can I leave the zero value as a blank and not affect the six digit number I want to create? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Combine two cells (numbers) but not add
Hi,
The first bit is straightforward =A1&B1 I don't understand the second bit please post an example of column A & B and the output you require in Column C. Mike "evoxfan" wrote: I have column A of cells containing three digit numbers in each cell. In column B, I have the same thing cells with three digit numbers. I would like to combine these two numbers into a six digit number. How can this be done? Also, in column B there are several cells with a zero value, so a blank is displayed. How can I make the zero values into three digits or can I leave the zero value as a blank and not affect the six digit number I want to create? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Combine two cells (numbers) but not add
Maybe this:
=TEXT(A1,"000")&TEXT(B1,"000") Note that this returns a *text string*, not a numeric number. -- Biff Microsoft Excel MVP "evoxfan" wrote in message ... I have column A of cells containing three digit numbers in each cell. In column B, I have the same thing cells with three digit numbers. I would like to combine these two numbers into a six digit number. How can this be done? Also, in column B there are several cells with a zero value, so a blank is displayed. How can I make the zero values into three digits or can I leave the zero value as a blank and not affect the six digit number I want to create? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Combine two cells (numbers) but not add
Thanks for the help, that works great on most all of the cells.
Here is an example of where it does don work: A1=190 B1=0 C1=A1&B1=1900 I would like C1=190000, but in order to do that I assume B1 has to have three digits. So how can I make B1 have three digits in this case? "Mike H" wrote: Hi, The first bit is straightforward =A1&B1 I don't understand the second bit please post an example of column A & B and the output you require in Column C. Mike "evoxfan" wrote: I have column A of cells containing three digit numbers in each cell. In column B, I have the same thing cells with three digit numbers. I would like to combine these two numbers into a six digit number. How can this be done? Also, in column B there are several cells with a zero value, so a blank is displayed. How can I make the zero values into three digits or can I leave the zero value as a blank and not affect the six digit number I want to create? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Combine two cells (numbers) but not add
Maybe
=IF(B2<0,A2&B2,A2&"000") Mike "evoxfan" wrote: Thanks for the help, that works great on most all of the cells. Here is an example of where it does don work: A1=190 B1=0 C1=A1&B1=1900 I would like C1=190000, but in order to do that I assume B1 has to have three digits. So how can I make B1 have three digits in this case? "Mike H" wrote: Hi, The first bit is straightforward =A1&B1 I don't understand the second bit please post an example of column A & B and the output you require in Column C. Mike "evoxfan" wrote: I have column A of cells containing three digit numbers in each cell. In column B, I have the same thing cells with three digit numbers. I would like to combine these two numbers into a six digit number. How can this be done? Also, in column B there are several cells with a zero value, so a blank is displayed. How can I make the zero values into three digits or can I leave the zero value as a blank and not affect the six digit number I want to create? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Combine two cells (numbers) but not add
I forgot to add this works for both so use this instead of the first formula
Mike "Mike H" wrote: Maybe =IF(B2<0,A2&B2,A2&"000") Mike "evoxfan" wrote: Thanks for the help, that works great on most all of the cells. Here is an example of where it does don work: A1=190 B1=0 C1=A1&B1=1900 I would like C1=190000, but in order to do that I assume B1 has to have three digits. So how can I make B1 have three digits in this case? "Mike H" wrote: Hi, The first bit is straightforward =A1&B1 I don't understand the second bit please post an example of column A & B and the output you require in Column C. Mike "evoxfan" wrote: I have column A of cells containing three digit numbers in each cell. In column B, I have the same thing cells with three digit numbers. I would like to combine these two numbers into a six digit number. How can this be done? Also, in column B there are several cells with a zero value, so a blank is displayed. How can I make the zero values into three digits or can I leave the zero value as a blank and not affect the six digit number I want to create? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Combine two cells (numbers) but not add
That Worked Great!
"T. Valko" wrote: Maybe this: =TEXT(A1,"000")&TEXT(B1,"000") Note that this returns a *text string*, not a numeric number. -- Biff Microsoft Excel MVP "evoxfan" wrote in message ... I have column A of cells containing three digit numbers in each cell. In column B, I have the same thing cells with three digit numbers. I would like to combine these two numbers into a six digit number. How can this be done? Also, in column B there are several cells with a zero value, so a blank is displayed. How can I make the zero values into three digits or can I leave the zero value as a blank and not affect the six digit number I want to create? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Combine two cells (numbers) but not add
Thanks for the feedback!
-- Biff Microsoft Excel MVP "evoxfan" wrote in message ... That Worked Great! "T. Valko" wrote: Maybe this: =TEXT(A1,"000")&TEXT(B1,"000") Note that this returns a *text string*, not a numeric number. -- Biff Microsoft Excel MVP "evoxfan" wrote in message ... I have column A of cells containing three digit numbers in each cell. In column B, I have the same thing cells with three digit numbers. I would like to combine these two numbers into a six digit number. How can this be done? Also, in column B there are several cells with a zero value, so a blank is displayed. How can I make the zero values into three digits or can I leave the zero value as a blank and not affect the six digit number I want to create? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using If to combine answers including text and numbers | Excel Worksheet Functions | |||
| Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
| how to combine numbers with the comma | Excel Worksheet Functions | |||
| Combine Cells | Excel Worksheet Functions | |||
| combine cells | Excel Discussion (Misc queries) | |||
Linear Mode
