View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default texttocolumn, limit the number of used columns to 1

It is treating the period as a wildcard. One thing you can do is replace the
period with the characters ZZ. Do the split. Then replace ZZ with a period.

"Tyrone" wrote:

hello,
I have a list of datanames with one or more extensions. is it possible to
perform one split only? I should look like:

---------------------
hello|abc.def

instead of:

---------------------
hello|abc|def

thanks in advance.
greetings