Removing text from cell

[L.LEE]

Hi. I have a cell that has this value "Qtr(2/14)" (without the colons). I would like another cell to refer to this cell and give me the value "(2/14)" without the "Qtr". Thanks.

[benishiryo]

hi there. it would be better to give us a few eg so that we can see the pattern. if it's always Qtr, maybe:
=SUBSTITUTE(A1,"Qtr","")

if it's always beginning of the bracket, then:
=MID(A1,FIND("(",A1),100)

[Mazzaropi]

L.LEE, Good morning.

If you have always the same pattern, you can try this one:

=Right(A1,6)

I hope it helps.

Have a nice day.

[L.LEE]

Pls refer to the attached file.

Cell A1 has original text.
Cell A2 deletes the text "Current Qtr."
I then Paste Value Cell A2 to Cell A3
When I double-clicked on Cell A3, I realized that the texts are on the second line i.e. there is a
hard return inserted into the Cell. How do I remove this? Thanks.

[Sam Capricci]

you can use =clean(text) and point the "text" part to the cell with the unwanted character in it.

[Sam Capricci]

Glad i could help and thanks for the bump to the reputation. Don't forget to mark your post as solved if it is.