TextAfter Solution

[Kmitchell]

Hello I am having difficulty extracting a number and including text that follows. The TTEXTAFTER(C53," ",-1) is not always working. Any recommended systematic approaches are greatly appreciated.

Column C is a drug product name. I want to display the formulation separately.

Here are a few examples:

NICOTROL INH = Formulation would be blank
ENTRING MIS 7.5/24HR = Formulation would be 7.5/24HR

LIDOCAINE SOL 4% = Formulation would be 4% RETACRIT INJ 20000UNI = Formulation would be 20000UNI ATROPINE SUL SOL 1% OP = Formulation would be 1% OP TRI-LO- TAB SPRINTEC = Formulation would be blank

 

[Scott Huish]

Perhaps:
=LET(a,MIN(IFERROR(FIND(SEQUENCE(10,,0),A1),"")),IF(a,MID(A1,a,255),""))

 

[Kmitchell]

Amazing solution, thank you!