LinkBack URL
About LinkBacks
Is it possible to "read 2 numbers" and add them together? For example, if I had the information "12-23" in a single cell, is there a way of adding the two numbers and showing the result in a separate cell?
Many thanks.
Is it possible to "read 2 numbers" and add them together? For example, if I had the information "12-23" in a single cell, is there a way of adding the two numbers and showing the result in a separate cell?
Many thanks.
Last edited by tom hatten; 08-18-2012 at 09:31 AM.
Assuming your 2 numbers are in A1, separated by a hyphen, then you can do this:
Formula:
Please Login or Register to view this content.
Hope this helps.
Pete
Thanks Pete, just what I wanted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks