RE: How to Combine two cells (numbers) but not add

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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?



.

Relevant Pages

  • RE: Count number of digits (Numbers)
    ... Fantastic - Thank you very much Mike ... equal to six digits if that makes any sense. ... Each cell is picking up ...
    (microsoft.public.excel.misc)
  • RE: VBA Macro change column contents
    ... Mike thanks sometimes it is so easy to look over the simple way out. ... "James C" wrote: ... change the 3 digits to become 4 digits, the new fourth digit has to be a ... may be 200 rows of data the next might be 300 and I would want the macro to ...
    (microsoft.public.excel.misc)
  • Re: How can I find repeated numbers that are transposed?
    ... you have the first formula. ... When I did the second formula, it only showed the word "OK" in the column. ... Use a helper column. ... How can I find the numbers that are repeated though their digits are ...
    (microsoft.public.excel.misc)
  • RE: change text to real dates
    ... Yes Mike; an excellent source ... "Jacob Skaria" wrote: ... i have extracted text within texts in a column of data thru left & right ... Days and the last 2 digits are Years. ...
    (microsoft.public.excel.misc)
  • RE: How to Combine two cells (numbers) but not add
    ... "evoxfan" wrote: ... So how can I make B1 have three digits in this case? ... I have the same thing cells with three digit numbers. ... Also, in column B there are several cells with a zero value, so a blank is ...
    (microsoft.public.excel.misc)