Removing my " " from a formula if the cells are empty with writing loads of ifs?

[tonywatsonhelp]

Hi Everyone,
I have a simple formula to combine a number of cells and put a space between each cell, the problem is not all the cells will always have data in them so I end up with lots of spaces in a row
if the first cell and last cell had names in them for example instead of "Tom Bill" I'd get "Tom BILL" you can see how this is annoying!
is there a way to only put the spaces between the cells with data in them?

this is the formula I currently use:

=$AI$27&" "&$AI$28&" "&$AI$29&" "&$AI$30&" "&$AI$31&" "&$AI$32&" "&$AI$33&" "&$AI$34&" "&$AI$35

thanks for your help

Tony

 

[Matty]

Wrapping the formula inside TRIM() should work.

Matty

 

[tonywatsonhelp]

Oh, wow, that's one I didn't think of, thank you very much for that,
Brilliant,
Thanks for your help.
Tony,