| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the "0" number is lost when combining multiple columns
Hello,
I have data in two columns (A and B) that I wish to combine into a third column (C) by using the "&" feature as follows: =A1&B1 The data in Column A is a product code # (i.e. 05296) The data in Column B are letters (i.e. MND) However, when I combine them both together in Column "C", I get "5296MND" instead of "05296MND". The "0" is missing. How I can maintain the integrity of the "0" and have it appear in the cell? Thank you in advance. Hal. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
the "0" number is lost when combining multiple columns
Try it in C1 as:
=TEXT(A1,"00000")&B1 where col A = prod codes -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Hal" wrote in message ... Hello, I have data in two columns (A and B) that I wish to combine into a third column (C) by using the "&" feature as follows: =A1&B1 The data in Column A is a product code # (i.e. 05296) The data in Column B are letters (i.e. MND) However, when I combine them both together in Column "C", I get "5296MND" instead of "05296MND". The "0" is missing. How I can maintain the integrity of the "0" and have it appear in the cell? Thank you in advance. Hal. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
the "0" number is lost when combining multiple columns
This should work,
the problem is that the format of cell A1, is not used when you have C1= A1 & B1 So you have to explicitly format A1 in the combine formula Steve On Thu, 25 Jan 2007 13:57:24 -0000, Max wrote: Try it in C1 as: =TEXT(A1,"00000")&B1 where col A = prod codes -- Steve (3) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
the "0" number is lost when combining multiple columns
Thank you Max for your help!
Hal "Max" wrote in message ... Try it in C1 as: =TEXT(A1,"00000")&B1 where col A = prod codes -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Hal" wrote in message ... Hello, I have data in two columns (A and B) that I wish to combine into a third column (C) by using the "&" feature as follows: =A1&B1 The data in Column A is a product code # (i.e. 05296) The data in Column B are letters (i.e. MND) However, when I combine them both together in Column "C", I get "5296MND" instead of "05296MND". The "0" is missing. How I can maintain the integrity of the "0" and have it appear in the cell? Thank you in advance. Hal. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
the "0" number is lost when combining multiple columns
Thank you Steve for your help!
Hal. "SteveW" wrote in message news:op.tmpu75abevjsnp@enigma03... This should work, the problem is that the format of cell A1, is not used when you have C1= A1 & B1 So you have to explicitly format A1 in the combine formula Steve On Thu, 25 Jan 2007 13:57:24 -0000, Max wrote: Try it in C1 as: =TEXT(A1,"00000")&B1 where col A = prod codes -- Steve (3) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
the "0" number is lost when combining multiple columns
You're welcome, Hal !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Hal" wrote in message ... Thank you Max for your help! Hal |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combining multiple columns from multiple files | Excel Discussion (Misc queries) | |||
| Combining Cell Contents - entire columns | Excel Worksheet Functions | |||
| How to determine the maximum lost? | Excel Discussion (Misc queries) | |||
| using functions to compare multiple columns for mismatch of cells | Excel Worksheet Functions | |||
| making multiple columns when printing long datasheet | Excel Discussion (Misc queries) | |||
Linear Mode
