I need to enter a space in a cell

[Velociter]

I need to enter a space in a cell using this formula ="[email protected]."&COLUMN(B:B)&":161::::2" I need the space to be after the 2


TIA

[Pete_UK]

Try this:

="[email protected]."&COLUMN(B:B)&":161::::2 "

I put the space after the final 2 - not sure which one you meant but if it is after the first 2 (and after the full-stop), then you can do this:

="[email protected]. "&COLUMN(B:B)&":161::::2"

Hope this helps.

Pete

[Velociter]

This is what happens when I do that ="\[email protected].="\[email protected]."&COLUMN(A:A)&":161::::2" B2 A B2 is added. Also this is the first cell and I'm filling to the right 254 times...