I inherited a complex spreadsheet that needs some changes. One change is to add a description to a cell that used to only be numeric. That's easy to do, but that cell is used to figure pricing for the identified option. When I make the change to add the text the calculations don't work. Is it possible to just locate numeric in first position in the cell and then ignore remaining text? Added a simple example worksheet. Thanks
If the number is always 1 digit and always the leftmost character of the text string, then something like LEFT(text,1) will return that number (as text). Excel automatically converts text to numbers when using the standard arithmetic operators (+,-,*,/) so something like =A7*LEFT(B7,1) will return the values you show in your sample.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks