View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
roouua
 
Posts: n/a
Default work with text and numbers

please help!!!
1.I have a text, for ex this one:'Pour calculer le nombre des entrées
potentielles, on a considéré quil y aura 15% des nuitées avec une 1 entrée
et 7,5% des nuitées avec 2 entrées : 1050+ (525*2)=2100 entrées potentielles
dans linter saison. '
This text was exported from Word and is seen as a single cell. When I want
to click Text to columns It sais that I cannot convert more than one column.
So I use Wrap text and split cells in order to have multiple cells on the
same text.When I try to for the fist cell for example Text to columns It sais
that 'no data was selected to parse'.
Thank you