Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

alpha character reference 1

Status
Not open for further replies.
Harley78

Harley78

Electrical
Joined
May 8, 2007
Messages
77
Location
US
I have been beating my head and cannot seem to figure it out, hopefully someone with more smarts than I can help me.

if I have a cell that contains characters,

e.g. Cell A10 contains OA/01 and now I am in Cell D4, I want to have this cell note that the second character (in this case "A")is Alpha and therefore, place a N in Cell D4.

IS THIS POSSIBLE? OR am I asking to much from Excel?

Thanks for any input or suggestions.
 
Sort by date Sort by votes
Yes, No

Look up the worksheet text functions

btw.. There is a spreadsheet forum on this site

TTFN

FAQ731-376


 
Upvote 0 Downvote
Sorry, new to this site,,,sorry for the problems and thanks for the info
 
Upvote 0 Downvote
Sorry again for being impolite,,, but can you steer me where this is? I can't seem to locate it....
 
Upvote 0 Downvote
THANKS SO MUCH, NOW I WON'T BE A BOTHER.... MANY THANKS
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

hostbuster
  • Locked
  • Question Question
Linux serial communication => nul characters
Replies
2
Views
182
hostbuster
hostbuster

Part and Inventory Search

Sponsor

Back
Top