G
Guest
EXcel 2000 on Win2000
Have to correct a column of names, some enter lname, fname others entered as
fname lname. Following formula correctly places those lname, fname entries(in
column D), however it returns that nasty #Value error for those that are
formatted correctly( inother words do not have the comma separating lname
from fname). My intentions were to simply copy the contents of the D cell, if
there were no ",".
What would be the best way to work around this frustration??
=IF(SEARCH(",", D2)>1,RIGHT(D2, LEN(D2)-(SEARCH(",", D2)+1))&" "&LEFT(D2,
(SEARCH(",", D2)-1)), D2)
Thanks for any and all pointers
Have to correct a column of names, some enter lname, fname others entered as
fname lname. Following formula correctly places those lname, fname entries(in
column D), however it returns that nasty #Value error for those that are
formatted correctly( inother words do not have the comma separating lname
from fname). My intentions were to simply copy the contents of the D cell, if
there were no ",".
What would be the best way to work around this frustration??
=IF(SEARCH(",", D2)>1,RIGHT(D2, LEN(D2)-(SEARCH(",", D2)+1))&" "&LEFT(D2,
(SEARCH(",", D2)-1)), D2)
Thanks for any and all pointers