Thread: Parse delimiter is change from text to numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ORLANDO V[_2_] ORLANDO V[_2_] is offline
external usenet poster
  
Posts: 37
Default Parse delimiter is change from text to numbers
I have a long list of items like this one below.
They consist of four things: Asset name, country, units, and market value.

Accor SA France 3,300,000 177,214,917

I want to parse this? Any ideas on the best way to do this? Open to all
suggestions. Prefer formulas over VBA for this one .
Reply With QuoteReply With Quote