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?

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?

=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?

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?

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?

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?

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?

=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?

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?

"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?