Nested IF and nested Concatenation formula

Hello

How do I say the following so that there is spaces between AA7 &, J7 and AA7 and J8 and AA7 and J9 please?

=IF(J7="",R7,AA7& J7),IF(J7="",R8,AA7& J8),IF(J7="",R9,AA7& J9)

The above creates one continuous string of characters. For the first part - IF(J7="",R7,AA7& J7) - only.

I think you want to do this:

=IF(J7="",R7&AA7&" "&J7&" "&R8&AA7&" "&J8&" "&R9&AA7&" "&J9,"")

If not, then tell us what you want to achieve in more detail.

Hope this helps.

Pete

Thanks for the effort Pete - your suggestion does not work.
Attached is an example WorkBook which may explain better.
There may be another formula you could recommend please..

The formula in K14 should be this:

=IF(C7="",G7,K7&" "&C7)

i.e. you add a space between the K7 and C7. Is that what you mean?

Hope this helps.

Pete

Great easy solution thank you Pete.
Now I have just realised when I clear the drop down in cell C7, I get L0 in cell K14 - which should be clear.
ow do I clear this when no entry in C7 please?

Try this in K14:

=IF(C7="","",K7&" "&C7)

Hope this helps.

Pete

Works Great thank you Pete.