View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tuli tuli is offline
external usenet poster
 
Posts: 7
Default open file with multiple types of delimiters

I have a file with the following format (n rows of):

Freq, Real+jImag which sometimes looks like

Freq, Real-jImag

I can tell excel to consider the coma as delimiter and only ONE option
for an arbitrary delimiter, say "+j". I would need another option for
an arbitrary delimiter for "-j".
Am I missing something, or this is a real limitation?

Thanks

Tuli