Copy & remove text before & after specific character

[mljohn]

How do I move to another column, all text from a cell that follows a specific character, such as ":"?

Also, How do I move to another column, all text from a cell that precedes a specific character, such as ">"?

 

[tufina85]

Hi all,
I have a very similar question. I need to strip off a cell all the content between the following characters []*, including the brackets


Example cell a1 contain

[00:00:00.000]Here's a loaner...[00:00:00.840] [00:00:00.914]Just be sure and juggle the handle a little to open the door.[00:00:03.257] I need a formula that copies just the brackets in the next cell b2 [00:00:00.000] [00:00:00.840] [00:00:00.914] [00:00:03.257] thanks a mill

<tbody>
</tbody>

Very precious commands.

How to do B2 if there is more than 2 words and multiple ":". For example Fred:Scuttle:Paris and I want to have only the last word? Right now it would give "Scuttle:Paris"

Thanks

 

[danpooler]

I have the same issue trying to copy the last of a string after ">" Example:

Pilot Supplies>Apparel & Eyewear>T-Shirts

Pilot Supplies>Bags & Cases>by Brand>ASA

<colgroup><col></colgroup><tbody>
</tbody>

In some cells, I have two ">" others I have three or more ">" I only want the text after the last ">"


=RIGHT(A14,LEN(A14)-FIND(">",A14)) GIves me the text after the first ">"


Thanks!!!

 

[danpooler]

I have the same issue trying to copy the last of a string after ">" Example:

Pilot Supplies>Apparel & Eyewear>T-Shirts

Pilot Supplies>Bags & Cases>by Brand>ASA

<tbody>
</tbody>

In some cells, I have two ">" others I have three or more ">" I only want the text after the last ">"


=RIGHT(A14,LEN(A14)-FIND(">",A14)) GIves me the text after the first ">"


Thanks!!!

I'm trying to have a column of just the last text IE: T-shirts and ASA.

 

[shg]

Welcome to the board.

Use Find & Replace: Find *> replace with nothing

 

[danpooler]

I don't think that is correct....

Column A

Pilot Supplies>Apparel & Eyewear>T-Shirts

Pilot Supplies>Bags & Cases>by Brand>ASA Column B needs to read everything after the last > sometimes there are 3 > sometimes there are 2 >... T-shirts ASA If I use the same code from the original question I would get: Apparel & Eyewear>T-Shirts Bags & Cases>by Brand>ASA Which is everything after the first >... I'm trying to get everything after the last...> <tbody> </tbody>

<tbody>
</tbody>

 

[shg]

Did you try it, or are you speculating?

 

[Rick Rothstein]

I don't think that is correct....

Did you notice the asterisk that is in front of the > symbol?

 

[danpooler]

Did you try it, or are you speculating?

I apologize your correct but I was hoping there was as formula so the data could be changing vs having to click and replace. However this helps me out quite a bit.

Thank you guys!

 

[Rick Rothstein]

...but I was hoping there was as formula...

Give this formula a try...

=TRIM(RIGHT(SUBSTITUTE(A1,">",REPT(" ",300)),300))

 

[danpooler]

Give this formula a try...

=TRIM(RIGHT(SUBSTITUTE(A1,">",REPT(" ",300)),300))

PERFECT!!!!!!!!!! Thank you