Thread: Split field based on number of characters and space
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
william_mailer william_mailer is offline
external usenet poster
  
Posts: 1
Default Split field based on number of characters and space

I have a string of text in a cell. I want to split the cell based on
anything over 30 characters. But I want to also split on a space. So
basically the first space before I reach 30 characters limit. Hope I
explained well !! Any help would be great !

Thanks


--
william_mailer
------------------------------------------------------------------------
william_mailer's Profile: http://www.excelforum.com/member.php...o&userid=31318
View this thread: http://www.excelforum.com/showthread...hreadid=510057

Reply With QuoteReply With Quote