Extracting Partial Text and copy to another cell

[Bvendett4]

Good Morning,
It may be easier to explian in a diagram below what I am trying to acheive.
Any help would be much appreciated.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Ideas
[/TD]
[TD]Date Created
[/TD]
[TD]Revised Date
[/TD]
[TD]Idea Rating
[/TD]
[/TR]
[TR]
[TD]Idea 101 Low
[/TD]
[TD]20/01/18
[/TD]
[TD] -
[/TD]
[TD]Cell reads whether text in Idea 101 Low, is Low, Medium or High and dispalys that value
[/TD]
[/TR]
[TR]
[TD]Idea 102 High
[/TD]
[TD]20/02/18
[/TD]
[TD] -
[/TD]
[TD]

Cell reads whether text in Idea 102 Medium, is Low, Medium or High and displays that value

<tbody>
</tbody>

[/TD]
[/TR]
[TR]
[TD]Idea 103 Medium
[/TD]
[TD]20/03/18
[/TD]
[TD] -
[/TD]
[TD]

Cell reads whether text in Idea 103 High, is Low, Medium or High and displays that value

<tbody>
</tbody>

[/TD]
[/TR]
</tbody>[/TABLE]

I know this seems like a silly requirment, but this is then read into another workbook that generates a database.
The value In Idea Rating column also allows a formula to read if the value is low it will add a time limit into the revision due date.
The ideas column are created via VBA into hyperlinks when a new file is saved into the correct filepath.

Many Thanks

 

[SteveO59L]

=IF(ISERROR(FIND("L",A2)),"","Low")&IF(ISERROR(FIND("M",A2)),"","Medium")&IF(ISERROR(FIND("H",A2)),"","High")

 

[Peter_SSs]

Try this, copied down

Excel Workbook
	A	B	C	D
1	Ideas	Date Created	Revised Date	Idea Rating
2	Idea 101 Low	20/01/2018	-	Low
3	Idea 102 High	20/02/2018	-	High
4	Idea 103 Medium	20/03/2018	-	Medium
LMH

 

[Joyner]

If the cells are always like this: Idea space 101 space then Low, Medium, or High, and all in one cell in that order, then try:

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),255))

Peter beat me to it...

and 10/10 probably makes more sense here.

 

[Peter_SSs]

and 10/10 probably makes more sense here.

Actually, if the only choices are Low, High & Medium we could reduce further to this.

=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",3)),6))

 

[SteveO59L]

even simpler

=MID(A2,10,6)

 

[Peter_SSs]

even simpler

=MID(A2,10,6)

Yes, provided the OP isn't ever going to have "Idea 68 Low" or "Idea 1234 Medium" or "Another Idea 123 High"