Little help please...
 

What I'm trying to do, which I hope I can.. is create an Excel form in which
I can enter a set of characters, Letters/Numbers only, in one column (one
character per field) and in the opposing column, display either Numeral X, or
the Alphanumeric for the character entered.

Can anyone give me some suggestions?

Little help please...
 

Are you looking for the Code worksheet function
=Code(65) returns "A"
--
HTH...

Jim Thomlinson


"Fraelorn" wrote:

What I'm trying to do, which I hope I can.. is create an Excel form in which
I can enter a set of characters, Letters/Numbers only, in one column (one
character per field) and in the opposing column, display either Numeral X, or
the Alphanumeric for the character entered.

Can anyone give me some suggestions?

Little help please...
 

=code(65) returns 54 for me. (the ascii code for 6)

=Code("A") would return 65

=Char(65) would return "A"

Not sure the OP want either of these, but just as additional information.

--
Regards,
Tom Ogilvy


"Jim Thomlinson" wrote:

Are you looking for the Code worksheet function
=Code(65) returns "A"
--
HTH...

Jim Thomlinson


"Fraelorn" wrote:

What I'm trying to do, which I hope I can.. is create an Excel form in which
I can enter a set of characters, Letters/Numbers only, in one column (one
character per field) and in the opposing column, display either Numeral X, or
the Alphanumeric for the character entered.

Can anyone give me some suggestions?

Little help please...
 

I am somewhat of a newbie when it comes to coding Excel. Where abouts would I
go to make use of this information, or could you possibly provide an example
of how to configure one set of cells for this?

ie. (information to be entered where 'C' is, Charlie should be the output)

[ A ] [ B ]
| C | Charlie |

Don't mean to take a bunch of your time for this, but would appreciate a
little more guidance. Thanks guys.


"Jim Thomlinson" wrote:

Are you looking for the Code worksheet function
=Code(65) returns "A"
--
HTH...

Jim Thomlinson


"Fraelorn" wrote:

What I'm trying to do, which I hope I can.. is create an Excel form in which
I can enter a set of characters, Letters/Numbers only, in one column (one
character per field) and in the opposing column, display either Numeral X, or
the Alphanumeric for the character entered.

Can anyone give me some suggestions?

Little help please...
 

Thanks Tom... I seem to have gotten it backwards.
--
HTH...

Jim Thomlinson


"Tom Ogilvy" wrote:

=code(65) returns 54 for me. (the ascii code for 6)

=Code("A") would return 65

=Char(65) would return "A"

Not sure the OP want either of these, but just as additional information.

--
Regards,
Tom Ogilvy


"Jim Thomlinson" wrote:

Are you looking for the Code worksheet function
=Code(65) returns "A"
--
HTH...

Jim Thomlinson


"Fraelorn" wrote:

What I'm trying to do, which I hope I can.. is create an Excel form in which
I can enter a set of characters, Letters/Numbers only, in one column (one
character per field) and in the opposing column, display either Numeral X, or
the Alphanumeric for the character entered.

Can anyone give me some suggestions?

Little help please...
 

In B1
=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false)

Before doing this, on another sheet put
ColumnA ColumnB
A Alpha
B Bravo
C Charlie
D Delta
E Echo
F Foxtrot

and so forth.

Select those cells and name them Table (insert=Name=Define)

--
Regards,
Tom Ogilvy

"Fraelorn" wrote:

I am somewhat of a newbie when it comes to coding Excel. Where abouts would I
go to make use of this information, or could you possibly provide an example
of how to configure one set of cells for this?

ie. (information to be entered where 'C' is, Charlie should be the output)

[ A ] [ B ]
| C | Charlie |

Don't mean to take a bunch of your time for this, but would appreciate a
little more guidance. Thanks guys.


"Jim Thomlinson" wrote:

Are you looking for the Code worksheet function
=Code(65) returns "A"
--
HTH...

Jim Thomlinson


"Fraelorn" wrote:

What I'm trying to do, which I hope I can.. is create an Excel form in which
I can enter a set of characters, Letters/Numbers only, in one column (one
character per field) and in the opposing column, display either Numeral X, or
the Alphanumeric for the character entered.

Can anyone give me some suggestions?

Little help please...
 

Thanks alot Tom :)


"Tom Ogilvy" wrote:

In B1
=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false)

Before doing this, on another sheet put
ColumnA ColumnB
A Alpha
B Bravo
C Charlie
D Delta
E Echo
F Foxtrot

and so forth.

Select those cells and name them Table (insert=Name=Define)

--
Regards,
Tom Ogilvy

"Fraelorn" wrote:

I am somewhat of a newbie when it comes to coding Excel. Where abouts would I
go to make use of this information, or could you possibly provide an example
of how to configure one set of cells for this?

ie. (information to be entered where 'C' is, Charlie should be the output)

[ A ] [ B ]
| C | Charlie |

Don't mean to take a bunch of your time for this, but would appreciate a
little more guidance. Thanks guys.


"Jim Thomlinson" wrote:

Are you looking for the Code worksheet function
=Code(65) returns "A"
--
HTH...

Jim Thomlinson


"Fraelorn" wrote:

What I'm trying to do, which I hope I can.. is create an Excel form in which
I can enter a set of characters, Letters/Numbers only, in one column (one
character per field) and in the opposing column, display either Numeral X, or
the Alphanumeric for the character entered.

Can anyone give me some suggestions?

Little help please...
 

Tom,
Your crystal ball is working wonders today, assumning you are correct.
From the OPs description, I was at a complete loss.

NickHK

"Tom Ogilvy" ...
In B1
=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false)

Before doing this, on another sheet put
ColumnA ColumnB
A Alpha
B Bravo
C Charlie
D Delta
E Echo
F Foxtrot

and so forth.

Select those cells and name them Table (insert=Name=Define)

--
Regards,
Tom Ogilvy

"Fraelorn" wrote:

I am somewhat of a newbie when it comes to coding Excel. Where abouts
would I
go to make use of this information, or could you possibly provide an
example
of how to configure one set of cells for this?

ie. (information to be entered where 'C' is, Charlie should be the
output)

[ A ] [ B ]
| C | Charlie |

Don't mean to take a bunch of your time for this, but would appreciate a
little more guidance. Thanks guys.


"Jim Thomlinson" wrote:

Are you looking for the Code worksheet function
=Code(65) returns "A"
--
HTH...

Jim Thomlinson


"Fraelorn" wrote:

What I'm trying to do, which I hope I can.. is create an Excel form
in which
I can enter a set of characters, Letters/Numbers only, in one column
(one
character per field) and in the opposing column, display either
Numeral X, or
the Alphanumeric for the character entered.

Can anyone give me some suggestions?

Little help please...
 

=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false)
should have a closing paren

=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false))

--
Regards,
Tom Ogilvy


"Fraelorn" wrote:

Thanks alot Tom :)


"Tom Ogilvy" wrote:

In B1
=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false)

Before doing this, on another sheet put
ColumnA ColumnB
A Alpha
B Bravo
C Charlie
D Delta
E Echo
F Foxtrot

and so forth.

Select those cells and name them Table (insert=Name=Define)

--
Regards,
Tom Ogilvy

"Fraelorn" wrote:

I am somewhat of a newbie when it comes to coding Excel. Where abouts would I
go to make use of this information, or could you possibly provide an example
of how to configure one set of cells for this?

ie. (information to be entered where 'C' is, Charlie should be the output)

[ A ] [ B ]
| C | Charlie |

Don't mean to take a bunch of your time for this, but would appreciate a
little more guidance. Thanks guys.


"Jim Thomlinson" wrote:

Are you looking for the Code worksheet function
=Code(65) returns "A"
--
HTH...

Jim Thomlinson


"Fraelorn" wrote:

What I'm trying to do, which I hope I can.. is create an Excel form in which
I can enter a set of characters, Letters/Numbers only, in one column (one
character per field) and in the opposing column, display either Numeral X, or
the Alphanumeric for the character entered.

Can anyone give me some suggestions?

Little help please...
 

Yeah, I noticed the missing paren and added it, however after entering the
table information and naming it, then adding the line into 'B1' on the first
sheet, it's generating "#NAME?" when entering any character from the list. I
must be missing something..


"Tom Ogilvy" wrote:

=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false)
should have a closing paren

=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false))

--
Regards,
Tom Ogilvy


"Fraelorn" wrote:

Thanks alot Tom :)


"Tom Ogilvy" wrote:

In B1
=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false)

Before doing this, on another sheet put
ColumnA ColumnB
A Alpha
B Bravo
C Charlie
D Delta
E Echo
F Foxtrot

and so forth.

Select those cells and name them Table (insert=Name=Define)

--
Regards,
Tom Ogilvy

"Fraelorn" wrote:

I am somewhat of a newbie when it comes to coding Excel. Where abouts would I
go to make use of this information, or could you possibly provide an example
of how to configure one set of cells for this?

ie. (information to be entered where 'C' is, Charlie should be the output)

[ A ] [ B ]
| C | Charlie |

Don't mean to take a bunch of your time for this, but would appreciate a
little more guidance. Thanks guys.


"Jim Thomlinson" wrote:

Are you looking for the Code worksheet function
=Code(65) returns "A"
--
HTH...

Jim Thomlinson


"Fraelorn" wrote:

What I'm trying to do, which I hope I can.. is create an Excel form in which
I can enter a set of characters, Letters/Numbers only, in one column (one
character per field) and in the opposing column, display either Numeral X, or
the Alphanumeric for the character entered.

Can anyone give me some suggestions?

Little help please...
 

Actually, it is working now, however I had to remove the

"if(isnumeric(A1),A1,"

from the previous recommendation. Any ideas why, or rather, what is this
piece of code suppose to signify?


"Fraelorn" wrote:

Yeah, I noticed the missing paren and added it, however after entering the
table information and naming it, then adding the line into 'B1' on the first
sheet, it's generating "#NAME?" when entering any character from the list. I
must be missing something..


"Tom Ogilvy" wrote:

=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false)
should have a closing paren

=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false))

--
Regards,
Tom Ogilvy


"Fraelorn" wrote:

Thanks alot Tom :)


"Tom Ogilvy" wrote:

In B1
=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false)

Before doing this, on another sheet put
ColumnA ColumnB
A Alpha
B Bravo
C Charlie
D Delta
E Echo
F Foxtrot

and so forth.

Select those cells and name them Table (insert=Name=Define)

--
Regards,
Tom Ogilvy

"Fraelorn" wrote:

I am somewhat of a newbie when it comes to coding Excel. Where abouts would I
go to make use of this information, or could you possibly provide an example
of how to configure one set of cells for this?

ie. (information to be entered where 'C' is, Charlie should be the output)

[ A ] [ B ]
| C | Charlie |

Don't mean to take a bunch of your time for this, but would appreciate a
little more guidance. Thanks guys.


"Jim Thomlinson" wrote:

Are you looking for the Code worksheet function
=Code(65) returns "A"
--
HTH...

Jim Thomlinson


"Fraelorn" wrote:

What I'm trying to do, which I hope I can.. is create an Excel form in which
I can enter a set of characters, Letters/Numbers only, in one column (one
character per field) and in the opposing column, display either Numeral X, or
the Alphanumeric for the character entered.

Can anyone give me some suggestions?

Little help please...
 

Let VBA creep into my worksheet formula. Should have been

=if(isnumber(A1),A1,vlookup(A1,Table,2,False))

You said you wanted to return the number if it was a number, so it adds that
part.

If you wanted

2 to return Two, then you would have to add that to your table.

--
Regards,
Tom Ogilvy



"Fraelorn" wrote:

Actually, it is working now, however I had to remove the

"if(isnumeric(A1),A1,"

from the previous recommendation. Any ideas why, or rather, what is this
piece of code suppose to signify?


"Fraelorn" wrote:

Yeah, I noticed the missing paren and added it, however after entering the
table information and naming it, then adding the line into 'B1' on the first
sheet, it's generating "#NAME?" when entering any character from the list. I
must be missing something..


"Tom Ogilvy" wrote:

=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false)
should have a closing paren

=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false))

--
Regards,
Tom Ogilvy


"Fraelorn" wrote:

Thanks alot Tom :)


"Tom Ogilvy" wrote:

In B1
=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false)

Before doing this, on another sheet put
ColumnA ColumnB
A Alpha
B Bravo
C Charlie
D Delta
E Echo
F Foxtrot

and so forth.

Select those cells and name them Table (insert=Name=Define)

--
Regards,
Tom Ogilvy

"Fraelorn" wrote:

I am somewhat of a newbie when it comes to coding Excel. Where abouts would I
go to make use of this information, or could you possibly provide an example
of how to configure one set of cells for this?

ie. (information to be entered where 'C' is, Charlie should be the output)

[ A ] [ B ]
| C | Charlie |

Don't mean to take a bunch of your time for this, but would appreciate a
little more guidance. Thanks guys.


"Jim Thomlinson" wrote:

Are you looking for the Code worksheet function
=Code(65) returns "A"
--
HTH...

Jim Thomlinson


"Fraelorn" wrote:

What I'm trying to do, which I hope I can.. is create an Excel form in which
I can enter a set of characters, Letters/Numbers only, in one column (one
character per field) and in the opposing column, display either Numeral X, or
the Alphanumeric for the character entered.

Can anyone give me some suggestions?

Little help please...
 

"After his second post, I was assuming the phonetic alphabet":

http://en.wikipedia.org/wiki/NATO_phonetic_alphabet

--
Regards,
Tom Ogilvy


"NickHK" wrote:

Tom,
Your crystal ball is working wonders today, assumning you are correct.
From the OPs description, I was at a complete loss.

NickHK

"Tom Ogilvy" ...
In B1
=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false)

Before doing this, on another sheet put
ColumnA ColumnB
A Alpha
B Bravo
C Charlie
D Delta
E Echo
F Foxtrot

and so forth.

Select those cells and name them Table (insert=Name=Define)

--
Regards,
Tom Ogilvy

"Fraelorn" wrote:

I am somewhat of a newbie when it comes to coding Excel. Where abouts
would I
go to make use of this information, or could you possibly provide an
example
of how to configure one set of cells for this?

ie. (information to be entered where 'C' is, Charlie should be the
output)

[ A ] [ B ]
| C | Charlie |

Don't mean to take a bunch of your time for this, but would appreciate a
little more guidance. Thanks guys.


"Jim Thomlinson" wrote:

Are you looking for the Code worksheet function
=Code(65) returns "A"
--
HTH...

Jim Thomlinson


"Fraelorn" wrote:

What I'm trying to do, which I hope I can.. is create an Excel form
in which
I can enter a set of characters, Letters/Numbers only, in one column
(one
character per field) and in the opposing column, display either
Numeral X, or
the Alphanumeric for the character entered.

Can anyone give me some suggestions?

Little help please...
 

Oh, yeah.. ok, that makes sense. Thanks again Tom.


"Tom Ogilvy" wrote:

Let VBA creep into my worksheet formula. Should have been

=if(isnumber(A1),A1,vlookup(A1,Table,2,False))

You said you wanted to return the number if it was a number, so it adds that
part.

If you wanted

2 to return Two, then you would have to add that to your table.

--
Regards,
Tom Ogilvy



"Fraelorn" wrote:

Actually, it is working now, however I had to remove the

"if(isnumeric(A1),A1,"

from the previous recommendation. Any ideas why, or rather, what is this
piece of code suppose to signify?


"Fraelorn" wrote:

Yeah, I noticed the missing paren and added it, however after entering the
table information and naming it, then adding the line into 'B1' on the first
sheet, it's generating "#NAME?" when entering any character from the list. I
must be missing something..


"Tom Ogilvy" wrote:

=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false)
should have a closing paren

=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false))

--
Regards,
Tom Ogilvy


"Fraelorn" wrote:

Thanks alot Tom :)


"Tom Ogilvy" wrote:

In B1
=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false)

Before doing this, on another sheet put
ColumnA ColumnB
A Alpha
B Bravo
C Charlie
D Delta
E Echo
F Foxtrot

and so forth.

Select those cells and name them Table (insert=Name=Define)

--
Regards,
Tom Ogilvy

"Fraelorn" wrote:

I am somewhat of a newbie when it comes to coding Excel. Where abouts would I
go to make use of this information, or could you possibly provide an example
of how to configure one set of cells for this?

ie. (information to be entered where 'C' is, Charlie should be the output)

[ A ] [ B ]
| C | Charlie |

Don't mean to take a bunch of your time for this, but would appreciate a
little more guidance. Thanks guys.


"Jim Thomlinson" wrote:

Are you looking for the Code worksheet function
=Code(65) returns "A"
--
HTH...

Jim Thomlinson


"Fraelorn" wrote:

What I'm trying to do, which I hope I can.. is create an Excel form in which
I can enter a set of characters, Letters/Numbers only, in one column (one
character per field) and in the opposing column, display either Numeral X, or
the Alphanumeric for the character entered.

Can anyone give me some suggestions?