ExcelBanter - add space between the results of a formula and text

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - add space between the results of a formula and text (https://www.excelbanter.com/excel-discussion-misc-queries/65381-add-space-between-results-formula-text.html)

rog

add space between the results of a formula and text

How do I add space between a formula and a word?

Dave Peterson

add space between the results of a formula and text

=sum(a1:a10)& " this is a word"

???

rog wrote:

How do I add space between a formula and a word?

--

Dave Peterson

Don Guillett

add space between the results of a formula and text

just add it.

=K8*7&" word " &K8*7

--
Don Guillett
SalesAid Software

"rog" wrote in message
...
How do I add space between a formula and a word?

All times are GMT +1. The time now is 12:50 AM.