Can I add cells that have text and numbers in them? Such as W12 or S10? Please let me know.
Can I add cells that have text and numbers in them? Such as W12 or S10? Please let me know.
Spud,
Welcome to the forum. Please read the rules and edit your thread title to be something more reflective of your problem.
To answer your question, if the cell begins with only one letter, you can do =Right(A1,Len(A1)-1)+Right(B1,Len(B1)-1).
Hello spud,
Welcome to the Forum!
As a new member of the forum, please take a few minutes and read the forum rules for posting and general etiquette. To see them, click on the link below...
Forum Rules
I changed your title for you this time because this is your first post.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks