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

work with text and numbers
 

I copied and pasted your text directly from your post into A1 of my test
book. I selected A1 and did Data TextToColumns Delimited using space
as the delimiter.........it appears to work fine. Perhaps you got a
corruption when you first imported from Word.

Vaya con Dios,
Chuck, CABGx3



"roouua" wrote:

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