i have bulk email fields placed in a Column



but it seems there are some spaces between some email ID's

is it possible to remove all spaces from the column

i mean something like

Find=<space>
Replace with=(what will i replace with?)

spaces means empty rows on that column, or what?

i just wrote like that <space>

actually i like to remove space (one single space not row or rows) in the field. i have many columns which contains E-mail ID's, sometimes there may be spaces between or middle or after the E-mail ID's because it is converted using some software. So, i like to take the spaces off the Email field.

I can find the space in the field with
Find=<space>(i mean a single space not any function) but i donno what to be replaced with

Replace with= ?

you can use this formula in another column: =SUBSTITUTE(D8;" ";"")
or, with find and replace, in find what line type a space, in the replace with, do not type anything; just click replace all...this should work... good luck!