Problem help - Microsoft Community

hi, have name joe in cell bn8. in cell a1 writing =bn8 name joe appears. why in cell a1 appears =bn8?

use replace under editing...

under find what: enter space

then click replace all

if want every space on whole sheet removed, click in just one cell , replace.

or if want spaces removed from a range of cells - select range first , replace.

Office / Excel / Windows 10 / Office 2010