Hi
could you explain what your expected result is with an example. Could be
done with a formula or a macro using Instr, Left, Mid

--
Regards
Frank Kabel
Frankfurt, Germany
"Ted Byrd" <Ted schrieb im Newsbeitrag
...
in excel macros seem to just copy the RESULTS of a macro performed on one
cell to another cell. what I need a macro to do is to perform the
keystrokes
in the new cell. The keystrokes above will remove all the spaces in a
cell
execpt for the first one. I don't want to effect whatever character is in
that first cell. the macro's i've created only copy the contents of the
1st
character from the cell which created the macro to wht new cell where the
macro is run.
Excel Office XP