CONCATENATE formula
When using the CONCATENATE formula, how do I get a space between the 2 fields
in the result cell? |
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? |
All times are GMT +1. The time now is 08:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com