Your problem is not with Excel. It is the other program's problem.

"Shackdelta" wrote:




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


--
Shackdelta
------------------------------------------------------------------------
Shackdelta's Profile: http://www.excelforum.com/member.php...fo&userid=9732
View this thread: http://www.excelforum.com/showthread...hreadid=477868