Adding spaces in IF formula

[bamaisgreat]

I am needing to add a few spaces between E3 and J3. Could someone help me modify the formula below.

=IF(E3="","",IF(C$3<>"",C$3&"","")&F3&" Rev "&E3)&J3

Thanks for the help

 

[RoryA]

Replace:

&E3)

with:

&E3&" ")

with however many spaces you want in there.

 

[Rick Rothstein]

I am needing to add a few spaces between E3 and J3. Could someone help me modify the formula below.

=IF(E3="","",IF(C$3<>"",C$3&"","")&F3&" Rev "&E3)&J3

Your question is not entirely clear to me, but if I had to guess I would think this may be what you are looking for...

=IF(E3="","",IF(C$3<>"",C$3&"","")&F3&" Rev "&E3&" ")&J3

Note: I only put one space between the quote marks shown in red... if you want more than one, just add them to what I already have there.

 

[bamaisgreat]

Perfect. Thanks