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;
- Jul 20 Thu 2006 20:08
work with text and numbers
close
全站熱搜
留言列表
發表留言