What is the formula to remove a character first and last of the text in a cell?
Example" *123456789*, i want to remove the * in the beginning and end
I tried this formula but i can only remove the first =MID(CELL, FIND("*", CELL) + 1, LEN(CELL))
What is the formula to remove a character first and last of the text in a cell?
Example" *123456789*, i want to remove the * in the beginning and end
I tried this formula but i can only remove the first =MID(CELL, FIND("*", CELL) + 1, LEN(CELL))
Last edited by angie_lin; 04-17-2024 at 04:03 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks