Re: display contents of preceeding cells consecutively

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

i HAVE TRIED THE VARIOUS MOTHODS AS WELL AS =CONCATENATE
AND ALL WORK
(I TRIED TO SAY I FOUND OUT HOW AFTER POSTING BUT WAS TAKING FOREVER TO
DISPLAY MY MESSAGE HERE

OOPS CAPS

1 problem though -- i have foced come colums to display zeros befor the number
ie 2 = 0002 etc
all these methods drop the prceeding 000
how can i force the concatenating to maintain them yet still display an
actual number ie not ""0002" or ooo2 - but 0002

"T. Valko" wrote:

Try this:

=--A1&B1&C1&D1&E1

That will return the result as a numeric number *but* this would be limited
to 15 digits. If the resulting string wll be longer than that then you'd
have to settle on the resulting string being *text* and remove the "--":

=A1&B1&C1&D1&E1

--
Biff
Microsoft Excel MVP


"EngelseBoer" <EngelseBoer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:407FCA0B-D7D5-488C-A3D4-0D5D9AC85DD8@xxxxxxxxxxxxxxxx
hi

I would like to display contents of preceeding cells consecutively
ie - generate a single number from numbers in 5 preceeding cells

How might i be able to do this please

eg.

A B C D E = F
2 24 15 76 99 = 224157699

much obliged for any help



.

Relevant Pages

  • Re: DisplayMember / ValueMember Question
    ... ComboBox can only be bound to a single value and single display column. ... > to concatenate multiple fields from a dataview for use as the value to ... > about a car, such as Make, Model, Year, etc. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: multiple fields from a combo box in a single field in related tabl
    ... primary key record, but assuming this is what you are doing: ... The drop-down combo box in the table will only display the first ... In the source query or Select Statement for the combo box, just concatenate ... combo box to display both fields from the table named "Powder". ...
    (microsoft.public.access.gettingstarted)
  • Excel Formula displays text of formula
    ... two cells =b2&b3 and it displayed the concatenated cells as it should. ... However, on worksheet 2, they tried to concatenate two cells again, but this ... it would not display the result, ... it quit working and went back to displaying the =c5&g5. ...
    (microsoft.public.excel.misc)
  • Re: Number format in a text field
    ... I did was created a Calculation field and just concatenated the four ... The Number field may DISPLAY as 0.123, ... When you concatenate a Number field to some text (with either a Number ... since the format can be different on every Layout. ...
    (comp.databases.filemaker)
  • Re: LaMarzocco GS3
    ... You just need a little antenna connector/screw on mini-antenna on the back ... Nothing is forever in computers. ... Using an interface of the type I described, you could, if you wanted to, ... display or keyboard interface at all - all communication takes place thru ...
    (alt.coffee)