Escanaba
asked on
Excel 2007 Formula to Pull Text Before A Certain Character
Hello,
Can someone provide a formula that will pull all the text in a cell that appears before the first appearance of {? For example, if the cell contains the following: Hello World {123} the formula would return: Hello World. If there is no { in the text string then it would just return the full text in the cell.
Thanks
Can someone provide a formula that will pull all the text in a cell that appears before the first appearance of {? For example, if the cell contains the following: Hello World {123} the formula would return: Hello World. If there is no { in the text string then it would just return the full text in the cell.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
pls try
Open in new window