Yes, if there is only one space I do not want to move it to another cell nor
delete the space. Any suggestions?

Bob Phillips wrote:
Does the question mean that if there is just one space you don't want to
split it? If not, you could use DataText To Columns delimited by space.

Can someone please tell me how to set a certain amount of spaces between text
in a given cell? Here is what I have:
[quoted text clipped - 18 lines]
whatever text is set more than 2 spaces and move it to the next cell? Any
answers?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1