Little help please...

[Guest]

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?

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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

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.

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

 

[Guest]

Thanks alot Tom

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

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.

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

Jim Thomlinson


:

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?

 

[NickHK]

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

NickHK

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

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.

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

Jim Thomlinson


:

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?

 

[Guest]

=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

Thanks alot Tom

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

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.


:

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

Jim Thomlinson


:

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?

 

[Guest]

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..

=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

Thanks alot Tom

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

:

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.


:

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

Jim Thomlinson


:

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?

 

[Guest]

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?

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..

=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

Thanks alot Tom


:

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

:

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.


:

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

Jim Thomlinson


:

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?

 

[Guest]

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

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?

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..

=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


:

Thanks alot Tom


:

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

:

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.


:

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

Jim Thomlinson


:

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?

 

[Guest]

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

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

--
Regards,
Tom Ogilvy

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

NickHK

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

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.


:

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

Jim Thomlinson


:

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?

 

[Guest]

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

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

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?

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..


:

=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


:

Thanks alot Tom


:

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

:

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.


:

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

Jim Thomlinson


:

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?