Cell Spacing

[omekoiks]

i did the replace command to take out the word the from the beginning of a bunch of entries...only problem is when i did that it left a space where "the" used to be...is there anyway to get rid of the space so the data starts where it should?

[daddylonglegs]

If you still have the original data then use Replace but remove "The "

(with a space at the end)

otherwise if your data is in A1 you could remove the space with a formula.

If all entries have a space at the beginning

=MID(A1,2,255)

or if only some do this will remove space from start of those that do but not alter the others.

=MID(A1,1+(LEFT(A1)=" "),255)

Once you have new data in separate column you can copy that column and use Edit > Paste Special > Values to turn into fixed values, and delete original column