Extracting Text in Cell

[Exceluser2984]

Hi,

I know how to extract text between special characters but my question has a little wrinkle. I have text that looks like the following:

253>9374
734>3949;3948>3448
3847;43548>3949
589

I want to extract the text to the right of the ">". There could be multiple strings in each cell to be extracted. So the expected result from the sample above would be:

9374
3949;3448
3847;3949
589

Any formulas to do this?

Thanks!

 

[tyija1995]

Hey,

I am slightly confused by your expected results.

The 1st expected result - fine
The 2nd implies you want the text after the first ">" and before the next ">"
The 3rd is confusing
The last one implies take the text as is if no ">"

If you truly want to extract text to the right of the ">" (assuming the first ">") then:
=MID(A1,SEARCH(CHAR(62),A1)+1,LEN(A1))

 

[Exceluser2984]

Thanks for responding. Each cell can have multiple values returned. The delimiter within each cell is a semicolon (. So if cell contains multiple semicolons then I want to return ever value to the right of the > and still have those values delimited by a semicolon. There may be instances where the there aren't 2 values separated by a > in that case I still want it returned.

 

[CANCER MAN]

Hello, Text to would work somewhat like this.

Excel 2013/2016
	A	B	C	D
1	253	9374		9374
2	734	3949;3948	3448	3949;3948
3	3847;43548	3949		3949
4	589			589
Worsheet

Cell Formulas
Range	Formula
D1	=IF(ISBLANK(B1),A1,B1)
D2	=IF(ISBLANK(B2),A2,B2)
D3	=IF(ISBLANK(B3),A3,B3)
D4	=IF(ISBLANK(B4),A4,B4)

 

[Exceluser2984]

That's pretty accurate - any way to get the formula into just once cell without having to break it down into multiple columns?