Remove all text left of certain text

[cfer]

Hi,

I have a column where in each cell there is a summary.

I want to be able to delete all the text and number's to the left, including the colon, in the cell with the following text.

Full description of Incident:

The text before can vary in length.

Formula, or VBA, as the column is dynamic.

I have tried

=RIGHT(N1,LEN(N1)-FIND("Incident:",N1))

it deletes everything but still leaves "ull description of Incident"

Thanks in advance

 

[steve the fish]

If you still want the "Full......" use this:

=TRIM(MID(A1,SEARCH("Full description of Incident:",A1),LEN(A1)))

if not:

=TRIM(MID(A1,SEARCH("Full description of Incident:",A1)+29,LEN(A1)))

 

[SteveO59L]

is

"Full description of Incident:" the entire entry?

if you delete all to the left of the ":" you wouldn't have anything?

 

[Rick Rothstein]

Your description of what you want is not all that clear. Are you trying to remove all the text before the first colon, plus the colon itself? If so, try this...

=TRIM(REPLACE(A1,1,FIND(":",A1),""))

 

[cfer]

Hi All,

Thanks all for the feedback,

Steve it worked excellent



Cfer