Spaces inserted in pasted formulas between 120th and 121st characters

[XOR LX]

Hi all,

Could anyone explain what sometimes causes an extra space to be inserted into a pasted formula after posting?

In the below thread, all of my formulas have had an extra space inserted, and all between the 120th and 121st characters.

http://www.mrexcel.com/forum/excel-questions/767839-choosing-options-out-array.html

Many thanks in advance

Regards

 

[Peter_SSs]

I don't know if it is always in that exact position but I have noticed it on occasions when long formulas are involved. I presume it it related to how the forum software parses the posted text, though it must have something to do with the actual formula text as it does not do this for all long formulas. All I can suggest is if you notice it happening & it is putting a space in a position that causes your formula to fail, try adding a space earlier in your formula where it isn't critical.

 

[XOR LX]

Thanks, Peter. Appreciate the response.

Yes, I noticed that it's not for all formulas that this occurs - will try to see if I can narrow down which characters are the likely culprits!

Regards