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 ">"?

 

[VoG]

Try like this

Excel Workbook
	A	B
1	Fred:Scuttle	Scuttle
2	Fred>Scuttle	Fred
Sheet14

 

[mljohn]

Thanks.

How do I at the same time remove from the original cell what was moved to the other column?

 

[VoG]

Try like this

Excel Workbook
	A	B	C
1	Fred:Scuttle	Scuttle	Fred:
2	Fred>Scuttle	Fred	>Scuttle
Sheet14

 

[mljohn]

Fantastic.

How would I move text to another column by finding the word "yield" and not only moving the word "yield" but several characters before it?

Such as "20,000 yield" or "(5,000 yield)" or "1500 yield".
The amounts change but not the word.

I don't want the parenthesis just for example "5,000 yield".

 

[VoG]

Maybe

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"yield",""),"(",""),")","")+0

 

[mljohn]

Sorry, that didn't work. Got a "Value" error

 

[VoG]

Give some examples of existing values.

 

[mljohn]

Drum (25 000 Yield)
Drum (30 000 Yield)
Drum (25 000 Yield)
Drum (40 000 Yield)
Drum (Yield 30 000)
Black Toner 10 000 Yield
Cyan Toner 6 600 Yield
Magenta Toner 6 600 Yield
Yellow Toner 6 600 Yield

 

[gilles2284]

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

Try like this

Sheet14

*	A	B
Fred:Scuttle	Scuttle
Fred>Scuttle	Fred

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:131px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula B1 =RIGHT(A1,LEN(A1)-FIND(":",A1)) B2 =LEFT(A2,FIND(">",A2)-1) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4