I have imported data from a survey tool into Excel. Unfortunately, instead of
importing the selected fields in a question with a number, it is imported and
shown as text (i.e. Question 1: Yes ( ), No (selected) instead of : Yes( ) No
(1))
Can anyone tell me how I can program the cells that they automatically
convert the text (selected) into a number?
Thanx
Try using "Edit - Replace"
In "Find What", enter:
<Space>(select)<Space>
"Replace with:
<Space(1)<Space>
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Greta" <[email protected]> wrote in message
news:[email protected]...
> I have imported data from a survey tool into Excel. Unfortunately, instead
of
> importing the selected fields in a question with a number, it is imported
and
> shown as text (i.e. Question 1: Yes ( ), No (selected) instead of : Yes( )
No
> (1))
>
> Can anyone tell me how I can program the cells that they automatically
> convert the text (selected) into a number?
>
> Thanx
I might have mis-read your post when you said to replace text with numbers.
My suggestion returns text that looks like a number.
If you need an actual number, as recognized by XL, post back with the
configuration of the data *after* it's in XL.
That is, exactly what data is in an individual cell?
The entire Answer, or just the parenthesis, or the Yes and No together with
the parenthesis ... or what?
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RagDyer" <[email protected]> wrote in message
news:%23I%[email protected]...
> Try using "Edit - Replace"
>
> In "Find What", enter:
> <Space>(select)<Space>
>
> "Replace with:
> <Space(1)<Space>
> --
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Greta" <[email protected]> wrote in message
> news:[email protected]...
> > I have imported data from a survey tool into Excel. Unfortunately,
instead
> of
> > importing the selected fields in a question with a number, it is
imported
> and
> > shown as text (i.e. Question 1: Yes ( ), No (selected) instead of :
Yes( )
> No
> > (1))
> >
> > Can anyone tell me how I can program the cells that they automatically
> > convert the text (selected) into a number?
> >
> > Thanx
>
thanks so much for your reply.
The exact data that is in the cell is the word "selected". I want to convert
all "selected" in the cells to a number. e.g. that excel automatically
converts the word once it is entered in the cell. So if I would type in
"selected" in the cell, it would change it automatically to a 1.
Thanks
"RagDyer" wrote:
> I might have mis-read your post when you said to replace text with numbers.
> My suggestion returns text that looks like a number.
>
> If you need an actual number, as recognized by XL, post back with the
> configuration of the data *after* it's in XL.
>
> That is, exactly what data is in an individual cell?
>
> The entire Answer, or just the parenthesis, or the Yes and No together with
> the parenthesis ... or what?
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
>
> "RagDyer" <[email protected]> wrote in message
> news:%23I%[email protected]...
> > Try using "Edit - Replace"
> >
> > In "Find What", enter:
> > <Space>(select)<Space>
> >
> > "Replace with:
> > <Space(1)<Space>
> > --
> > HTH,
> >
> > RD
> > ==============================================
> > Please keep all correspondence within the Group, so all may benefit!
> > ==============================================
> >
> >
> > "Greta" <[email protected]> wrote in message
> > news:[email protected]...
> > > I have imported data from a survey tool into Excel. Unfortunately,
> instead
> > of
> > > importing the selected fields in a question with a number, it is
> imported
> > and
> > > shown as text (i.e. Question 1: Yes ( ), No (selected) instead of :
> Yes( )
> > No
> > > (1))
> > >
> > > Can anyone tell me how I can program the cells that they automatically
> > > convert the text (selected) into a number?
> > >
> > > Thanx
> >
>
>
If I understand what you're asking, you're talking about two different
things here.
1] You're talking about *replacing* imported data?!?!
2] You're talking about *entering* new data?!?!
Do I understanding your question?
For number 1, my original suggestion will still work, if you just revise the
parameters *and* the cells are not formatted to Text:
In "Find What", enter "select" (no quotes).
In "Replace With", enter "1" (no quotes).
For number 2, you'll have to tell me why, if you can enter the word
"select", you can't just as well enter the number "1".
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Greta" <[email protected]> wrote in message
news:[email protected]...
> thanks so much for your reply.
>
> The exact data that is in the cell is the word "selected". I want to
convert
> all "selected" in the cells to a number. e.g. that excel automatically
> converts the word once it is entered in the cell. So if I would type in
> "selected" in the cell, it would change it automatically to a 1.
>
> Thanks
>
> "RagDyer" wrote:
>
> > I might have mis-read your post when you said to replace text with
numbers.
> > My suggestion returns text that looks like a number.
> >
> > If you need an actual number, as recognized by XL, post back with the
> > configuration of the data *after* it's in XL.
> >
> > That is, exactly what data is in an individual cell?
> >
> > The entire Answer, or just the parenthesis, or the Yes and No together
with
> > the parenthesis ... or what?
> > --
> > Regards,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
-
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
-
> >
> > "RagDyer" <[email protected]> wrote in message
> > news:%23I%[email protected]...
> > > Try using "Edit - Replace"
> > >
> > > In "Find What", enter:
> > > <Space>(select)<Space>
> > >
> > > "Replace with:
> > > <Space(1)<Space>
> > > --
> > > HTH,
> > >
> > > RD
> > > ==============================================
> > > Please keep all correspondence within the Group, so all may benefit!
> > > ==============================================
> > >
> > >
> > > "Greta" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > I have imported data from a survey tool into Excel. Unfortunately,
> > instead
> > > of
> > > > importing the selected fields in a question with a number, it is
> > imported
> > > and
> > > > shown as text (i.e. Question 1: Yes ( ), No (selected) instead of :
> > Yes( )
> > > No
> > > > (1))
> > > >
> > > > Can anyone tell me how I can program the cells that they
automatically
> > > > convert the text (selected) into a number?
> > > >
> > > > Thanx
> > >
> >
> >
HI,
I know about (1).
The problem is that my data is collected through a survey whose results are
stored in a "excel-like" format. We are talking about 2000 lines with 156
rows. That's why I do not want to manually change "selected" to 1. And
certainly, I could do your suggestion (1), however I thought there must be
something else than find&replace.
Thanks for all your suggestions. I will try and see how I get along with
find&Replace
"RagDyer" wrote:
> If I understand what you're asking, you're talking about two different
> things here.
>
> 1] You're talking about *replacing* imported data?!?!
> 2] You're talking about *entering* new data?!?!
>
> Do I understanding your question?
>
> For number 1, my original suggestion will still work, if you just revise the
> parameters *and* the cells are not formatted to Text:
>
> In "Find What", enter "select" (no quotes).
> In "Replace With", enter "1" (no quotes).
>
> For number 2, you'll have to tell me why, if you can enter the word
> "select", you can't just as well enter the number "1".
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
>
>
> "Greta" <[email protected]> wrote in message
> news:[email protected]...
> > thanks so much for your reply.
> >
> > The exact data that is in the cell is the word "selected". I want to
> convert
> > all "selected" in the cells to a number. e.g. that excel automatically
> > converts the word once it is entered in the cell. So if I would type in
> > "selected" in the cell, it would change it automatically to a 1.
> >
> > Thanks
> >
> > "RagDyer" wrote:
> >
> > > I might have mis-read your post when you said to replace text with
> numbers.
> > > My suggestion returns text that looks like a number.
> > >
> > > If you need an actual number, as recognized by XL, post back with the
> > > configuration of the data *after* it's in XL.
> > >
> > > That is, exactly what data is in an individual cell?
> > >
> > > The entire Answer, or just the parenthesis, or the Yes and No together
> with
> > > the parenthesis ... or what?
> > > --
> > > Regards,
> > >
> > > RD
> > >
> >
> > --------------------------------------------------------------------------
> -
> > > Please keep all correspondence within the NewsGroup, so all may benefit
> !
> >
> > --------------------------------------------------------------------------
> -
> > >
> > > "RagDyer" <[email protected]> wrote in message
> > > news:%23I%[email protected]...
> > > > Try using "Edit - Replace"
> > > >
> > > > In "Find What", enter:
> > > > <Space>(select)<Space>
> > > >
> > > > "Replace with:
> > > > <Space(1)<Space>
> > > > --
> > > > HTH,
> > > >
> > > > RD
> > > > ==============================================
> > > > Please keep all correspondence within the Group, so all may benefit!
> > > > ==============================================
> > > >
> > > >
> > > > "Greta" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > I have imported data from a survey tool into Excel. Unfortunately,
> > > instead
> > > > of
> > > > > importing the selected fields in a question with a number, it is
> > > imported
> > > > and
> > > > > shown as text (i.e. Question 1: Yes ( ), No (selected) instead of :
> > > Yes( )
> > > > No
> > > > > (1))
> > > > >
> > > > > Can anyone tell me how I can program the cells that they
> automatically
> > > > > convert the text (selected) into a number?
> > > > >
> > > > > Thanx
> > > >
> > >
> > >
>
>
Don't forget what I said about the cells *not* being formatted as Text.
"Edit - Replace" will not change the format for you, but will return a
*Text* "1".
Do you really need a "real" number? ... for further calculations?
Don't forget, if you're totaling, SUM() *will* work with "Text" numbers.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Greta" <[email protected]> wrote in message
news:[email protected]...
> HI,
>
> I know about (1).
>
> The problem is that my data is collected through a survey whose results
are
> stored in a "excel-like" format. We are talking about 2000 lines with 156
> rows. That's why I do not want to manually change "selected" to 1. And
> certainly, I could do your suggestion (1), however I thought there must be
> something else than find&replace.
> Thanks for all your suggestions. I will try and see how I get along with
> find&Replace
>
> "RagDyer" wrote:
>
> > If I understand what you're asking, you're talking about two different
> > things here.
> >
> > 1] You're talking about *replacing* imported data?!?!
> > 2] You're talking about *entering* new data?!?!
> >
> > Do I understanding your question?
> >
> > For number 1, my original suggestion will still work, if you just revise
the
> > parameters *and* the cells are not formatted to Text:
> >
> > In "Find What", enter "select" (no quotes).
> > In "Replace With", enter "1" (no quotes).
> >
> > For number 2, you'll have to tell me why, if you can enter the word
> > "select", you can't just as well enter the number "1".
> > --
> > Regards,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
-
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
-
> >
> >
> > "Greta" <[email protected]> wrote in message
> > news:[email protected]...
> > > thanks so much for your reply.
> > >
> > > The exact data that is in the cell is the word "selected". I want to
> > convert
> > > all "selected" in the cells to a number. e.g. that excel automatically
> > > converts the word once it is entered in the cell. So if I would type
in
> > > "selected" in the cell, it would change it automatically to a 1.
> > >
> > > Thanks
> > >
> > > "RagDyer" wrote:
> > >
> > > > I might have mis-read your post when you said to replace text with
> > numbers.
> > > > My suggestion returns text that looks like a number.
> > > >
> > > > If you need an actual number, as recognized by XL, post back with
the
> > > > configuration of the data *after* it's in XL.
> > > >
> > > > That is, exactly what data is in an individual cell?
> > > >
> > > > The entire Answer, or just the parenthesis, or the Yes and No
together
> > with
> > > > the parenthesis ... or what?
> > > > --
> > > > Regards,
> > > >
> > > > RD
> > > >
> > >
> >
> --------------------------------------------------------------------------
> > -
> > > > Please keep all correspondence within the NewsGroup, so all may
benefit
> > !
> > >
> >
> --------------------------------------------------------------------------
> > -
> > > >
> > > > "RagDyer" <[email protected]> wrote in message
> > > > news:%23I%[email protected]...
> > > > > Try using "Edit - Replace"
> > > > >
> > > > > In "Find What", enter:
> > > > > <Space>(select)<Space>
> > > > >
> > > > > "Replace with:
> > > > > <Space(1)<Space>
> > > > > --
> > > > > HTH,
> > > > >
> > > > > RD
> > > > > ==============================================
> > > > > Please keep all correspondence within the Group, so all may
benefit!
> > > > > ==============================================
> > > > >
> > > > >
> > > > > "Greta" <[email protected]> wrote in message
> > > > > news:[email protected]...
> > > > > > I have imported data from a survey tool into Excel.
Unfortunately,
> > > > instead
> > > > > of
> > > > > > importing the selected fields in a question with a number, it is
> > > > imported
> > > > > and
> > > > > > shown as text (i.e. Question 1: Yes ( ), No (selected) instead
of :
> > > > Yes( )
> > > > > No
> > > > > > (1))
> > > > > >
> > > > > > Can anyone tell me how I can program the cells that they
> > automatically
> > > > > > convert the text (selected) into a number?
> > > > > >
> > > > > > Thanx
> > > > >
> > > >
> > > >
> >
> >
Just had a thought.
I can't try it myself right now, but maybe you can.
*Before* importing, try "AutoCorrect", and set it up so that "select" (no
quotes) is replaced with a 1.
Love to know if that would work!<g>
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Greta" <[email protected]> wrote in message
news:[email protected]...
> HI,
>
> I know about (1).
>
> The problem is that my data is collected through a survey whose results
are
> stored in a "excel-like" format. We are talking about 2000 lines with 156
> rows. That's why I do not want to manually change "selected" to 1. And
> certainly, I could do your suggestion (1), however I thought there must be
> something else than find&replace.
> Thanks for all your suggestions. I will try and see how I get along with
> find&Replace
>
> "RagDyer" wrote:
>
> > If I understand what you're asking, you're talking about two different
> > things here.
> >
> > 1] You're talking about *replacing* imported data?!?!
> > 2] You're talking about *entering* new data?!?!
> >
> > Do I understanding your question?
> >
> > For number 1, my original suggestion will still work, if you just revise
the
> > parameters *and* the cells are not formatted to Text:
> >
> > In "Find What", enter "select" (no quotes).
> > In "Replace With", enter "1" (no quotes).
> >
> > For number 2, you'll have to tell me why, if you can enter the word
> > "select", you can't just as well enter the number "1".
> > --
> > Regards,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
-
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
-
> >
> >
> > "Greta" <[email protected]> wrote in message
> > news:[email protected]...
> > > thanks so much for your reply.
> > >
> > > The exact data that is in the cell is the word "selected". I want to
> > convert
> > > all "selected" in the cells to a number. e.g. that excel automatically
> > > converts the word once it is entered in the cell. So if I would type
in
> > > "selected" in the cell, it would change it automatically to a 1.
> > >
> > > Thanks
> > >
> > > "RagDyer" wrote:
> > >
> > > > I might have mis-read your post when you said to replace text with
> > numbers.
> > > > My suggestion returns text that looks like a number.
> > > >
> > > > If you need an actual number, as recognized by XL, post back with
the
> > > > configuration of the data *after* it's in XL.
> > > >
> > > > That is, exactly what data is in an individual cell?
> > > >
> > > > The entire Answer, or just the parenthesis, or the Yes and No
together
> > with
> > > > the parenthesis ... or what?
> > > > --
> > > > Regards,
> > > >
> > > > RD
> > > >
> > >
> >
> --------------------------------------------------------------------------
> > -
> > > > Please keep all correspondence within the NewsGroup, so all may
benefit
> > !
> > >
> >
> --------------------------------------------------------------------------
> > -
> > > >
> > > > "RagDyer" <[email protected]> wrote in message
> > > > news:%23I%[email protected]...
> > > > > Try using "Edit - Replace"
> > > > >
> > > > > In "Find What", enter:
> > > > > <Space>(select)<Space>
> > > > >
> > > > > "Replace with:
> > > > > <Space(1)<Space>
> > > > > --
> > > > > HTH,
> > > > >
> > > > > RD
> > > > > ==============================================
> > > > > Please keep all correspondence within the Group, so all may
benefit!
> > > > > ==============================================
> > > > >
> > > > >
> > > > > "Greta" <[email protected]> wrote in message
> > > > > news:[email protected]...
> > > > > > I have imported data from a survey tool into Excel.
Unfortunately,
> > > > instead
> > > > > of
> > > > > > importing the selected fields in a question with a number, it is
> > > > imported
> > > > > and
> > > > > > shown as text (i.e. Question 1: Yes ( ), No (selected) instead
of :
> > > > Yes( )
> > > > > No
> > > > > > (1))
> > > > > >
> > > > > > Can anyone tell me how I can program the cells that they
> > automatically
> > > > > > convert the text (selected) into a number?
> > > > > >
> > > > > > Thanx
> > > > >
> > > >
> > > >
> >
> >
The other guy was going on a bit. Did you ever work an autocomplete solution?
thanks
rish
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks