Here is what I have.
A1 looks like this
ALBMDSP302 fc1/25
I need fc1/25 in another cell
Sometimes the fc number is bigger like fc10/25 so it's not always the same amount of characters
Is there a formula for this?
Here is what I have.
A1 looks like this
ALBMDSP302 fc1/25
I need fc1/25 in another cell
Sometimes the fc number is bigger like fc10/25 so it's not always the same amount of characters
Is there a formula for this?
Assuming your text is in cell A1, enter =RIGHT(A1,LEN(A1)-FIND(" ",A1))
That worked perfectly. Thanks so much for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks