| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
CONCATENATE formula
When using the CONCATENATE formula, how do I get a space between the 2 fields
in the result cell? |
|
#2
|
|||
|
|||
|
Hi
=CONCATENATE(A1," ",B1) or slightly less typing =A1 & " " & B1 -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "jkeeton" wrote in message ... When using the CONCATENATE formula, how do I get a space between the 2 fields in the result cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with a formula for concatenate and search/find with 3 columns | Excel Worksheet Functions | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
| Portion of concatenate formula to have different color and font fo | Excel Worksheet Functions | |||
| Use numbers in CONCATENATE formula without getting error | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
