close

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
I copied and pasted your text directly from your post into A1 of my test
book. I selected A1 and did Data gt; TextToColumns gt; Delimited gt; 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
quot;roouuaquot; wrote:

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()