I have made a spreadsheet that is gathering details from the user and then forming a string.

However, in the 6th section of 8 it is causing problems.

the formulas are all much the same. an example is shown below:-

=if(b268="","",f88)

Now, B268 is empty, so the "" criteria is met, but instead of being nothing, the spreadsheet is counting this as a space, so that when the text is pasted into another program, extra spaces are added! However, the Len of the above cell is 0, meaning it has no value whatsoever.

Does anyone know anything about this?

Thanks.

Shackdelta