Adding Spaces into Text

[padillacassandra]

Hi everyone!

I used a concatenate formula to combine a set of address columns into a full address column.

My only issue is that the spaces were not added between words. Can you help me do this?

Currently all the addresses look like this: [TABLE="width: 427"]
<tbody>[TR]
[TD="width: 427"]000 Peach StreetDentonTX76209

How can I make a formula to add spaces in the required areas?

Thank you in advance![/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott T]

you need to add the spaces where you want them.

for example

Book1
	B	C	D	E	F
2	123	peach street	denton	tx	6209
3
4	123 peach street denton tx 6209
Sheet3

Cell Formulas
Range	Formula
B4	=B2&" "&C2&" "&D2&" "&E2&" "&F2

If you have access to textjoin then you can use that
https://support.office.com/en-us/article/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c