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[TABLE="width: 284"]
<tbody>[TR]
[TD="class: xl64, width: 284"][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
[/TD]
[/TR]
</tbody>[/TABLE]

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:

[TABLE="width: 429"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Pilot Supplies>Apparel & Eyewear>T-Shirts [/TD]
[/TR]
[TR]
[TD]Pilot Supplies>Bags & Cases>by Brand>ASA[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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:

[TABLE="width: 429"]
<tbody>[TR]
[TD]Pilot Supplies>Apparel & Eyewear>T-Shirts[/TD]
[/TR]
[TR]
[TD]Pilot Supplies>Bags & Cases>by Brand>ASA[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="class: cms_table, width: 429"]
<tbody>[TR]
[TD]Pilot Supplies>Apparel & Eyewear>T-Shirts[/TD]
[/TR]
[TR]
[TD]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:
[TABLE="class: cms_table, width: 429"]
<tbody>[TR]
[TD]Apparel & Eyewear>T-Shirts[/TD]
[/TR]
[TR]
[TD]Bags & Cases>by Brand>ASA

Which is everything after the first >... I'm trying to get everything after the last...>[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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