View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.newusers
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Regional Settings / Finding out Array separator characters

On Thu, 24 Dec 2009 11:59:20 -0500, "T. Valko" wrote:

If all else fails, as a last resort you could transpose the array.

Since they know a vertical array uses the semi-colon transpose that into a
horizontal array:

TRANSPOSE({1;2;3})


I would be surprised if the macro I provided did not enable the OP to sort this
out, using the appropriate separators.
--ron