Re: Concatenating fields

<chris.nebinger@xxxxxxxxx> schreef in bericht
In your original expression, if ANY of the fields were null, the whole
result would be null. If you replaced them with Ampersands, then there
might be extra spaces. My solution:


Expr2: [Letter] & " "+[Prefix] & " "+[Surname]

Cool! Thanks.
john


.

Relevant Pages

  • Re: Formatting help
    ... " John Smith" in A1 (one space at the ... any extra spaces - you can use the TRIM function to do this. ... Barry Z.  On the next which is Paula Gonsalves i get last name ok but the ...
    (microsoft.public.excel.worksheet.functions)
  • Re: start up macro
    ... Rgds ... John ... >> schreef in bericht ...
    (microsoft.public.project2000)
  • Re: start up macro
    ... Rgds ... John ... >> schreef in bericht ...
    (microsoft.public.project2000)
  • Re: K Map solution
    ... > bericht news:8vkrj0td7qnsc9ps2olov3f83r04b4jk9t@4ax.com... ... >> If I'm doing discrete logic, I just sort of look at it. ... aren't k maps considered an academic/textbook-only method? ...
    (sci.electronics.design)
  • Re: COUNTIF
    ... It works, so long as the entries for "D" types have no extra spaces, and same ... >>> by John in Column C. ... >>> D ATLANTIC PKG. ...
    (microsoft.public.excel.misc)