Example: if you have a an excel sheet with a cell that has Pronetsys = Lightspeed and you want to get what comes after the = sign here is the formula.
The solution
=RIGHT(A1,LEN(A1)-FIND("=",A1)-1)
The above will return Lightspeed only if.
Pronetsys = Lightspeed is in cell A1
if you wanted to return Pronetsys
Solution
=LEFT(A1,LEN(A1)-FIND("=",A1)-1)
another solution would be
=MID(A2,1,FIND(",",A2)-1)
- 1 Users Found This Useful
Related Articles
Lesson 1: Entering Text and Numbers
The Microsoft Excel Window Microsoft Excel is an electronic spreadsheet. You can use it to...
Lesson 2: Entering Excel Formulas and Formatting Data
Lesson 1 familiarized you with the Excel 2007 window, taught you how to move around the window,...
Lesson 3: Creating Excel Functions, Filling Cells, and Printing
Lesson 3: Creating Excel Functions, Filling Cells, and Printing By using functions, you can...
Lesson 4: Creating Charts
In Microsoft Excel, you can represent numbers in a chart. On the Insert tab, you can choose from...
Unable to Open Excel files - Solution Fix
Fix: Error when double clicking an Excel file: Windows cannot find the file If you don’t...
