work with text and numbers

[Guest]

please help!!!
1.I have a text, for ex this one:'Pour calculer le nombre des entrées
potentielles, on a considéré qu’il 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 l’inter 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

 

[Guest]

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