Thread: Split field
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
dk dk is offline
external usenet poster
 
Posts: 129
Default Split field

only the last if there is 1 it's should go in column 2 all others in column
1 bassically only the last in column 2, column 2 shall not be empty

"Ron Rosenfeld" wrote:

On Sat, 29 Dec 2007 19:39:00 -0800, dk wrote:

how abou a fieild with only 2,3 words havin the first column everything
besides last word in 1 column last word in second column?





If there are only 2,3 words, do you want the last word in column 3 (lined up
with the last word if there are more than 3 words) or do you want the last word
in column 2?

What about if there is only one word?

What do you want to display if there are no words? -- <blank? <error
message?
--ron