![]() ![]() Please let me know if you need any further information to help. Here are some examples not much different from my post but may be clearer. The same formula must be used in column C for all rows. ![]() The same formula must be used in column B for all rows. The result generated in column B must be numeric, the result generated in Column C is text. The code provided is currently a text string. If they begin to add multiple letters at the end of the code, I will deal with it at that time. For now, let's assume that those are the only 2 cases. I am just provided with a code that is a number with no letter, or a number with one letter. I added the dashes, just to separate the columns. At this point it is a single letter, but I am not sure what they will do in the future, so I was looking for a solution that might eventually accommodate the need to add AA, etc. I tried substituting A,B,C etc for the numbers above, but the formula is not understood My original formula breaks up the string into several pieces, the CSE tells Excel to look at all the pieces, and the MAX picks out one answer from the internal array. A typical formula does one thing (A1+1), an array formula does several things. I need the formula to separate first and last name into a new column and a second formula to capture the information in the parenthesis. Problem is I can only figure out how to do it by number of characters. Given Data-Need formula to retrieve number-Need formula to retrieve lettersħ9-79ħ9A-79-AĢ34-234Ģ34A-234-AĢ34B-234-B The Control+Shift+Enter (CSE) means its an array formula. Using the LEFT or RIGHT formula currently as a means to separate the Sales Rep Info column. Use following functions to separate your text and numbers from a cell. I have seen the following and can get it to work if a cell has BA123 in it: I need help with a formula to separate my numbers from text in a cell.
0 Comments
Leave a Reply. |