Confusing output from cells

[Shackdelta]

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

[Mike]

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
>
>

[Shackdelta]

Thanks for that. I had already thought of that problem. It's not the other program that's doing it.

If I copy the section that is the problem (section 6) and paste it into Word, it comes up with a whole load of blank cells. However, for each of these blank cells that are shown, a space is added to the other program.

I would have thought that was the problem, but for the fact that in similar formulae that are in use in the spreadsheet, when a blank cell is shown no spaces are added.

Thanks again,

Shackdelta