Try like this
Sheet14
A B 1 Fred:Scuttle Scuttle 2 Fred>Scuttle Fred
Spreadsheet Formulas
Cell Formula B1 =RIGHT(A1,LEN(A1)-FIND(":",A1)) B2 =LEFT(A2,FIND(">",A2)-1)
Excel tables to the web >> Excel Jeanie HTML 4
This is a discussion on Copy & remove text before & after specific character within the Excel Questions forums, part of the Question Forums category; How do I move to another column, all text from a cell that follows a specific character, such as ":"? ...
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 ">"?
Try like this
Sheet14
A B 1 Fred:Scuttle Scuttle 2 Fred>Scuttle Fred
Spreadsheet Formulas
Cell Formula B1 =RIGHT(A1,LEN(A1)-FIND(":",A1)) B2 =LEFT(A2,FIND(">",A2)-1)
Excel tables to the web >> Excel Jeanie HTML 4
HTH, Peter
Please test any code on a copy of your workbook.
Thanks.
How do I at the same time remove from the original cell what was moved to the other column?
Try like this
Sheet14
A B C 1 Fred:Scuttle Scuttle Fred: 2 Fred>Scuttle Fred >Scuttle
Spreadsheet Formulas
Cell Formula B1 =RIGHT(A1,LEN(A1)-FIND(":",A1)) C1 =SUBSTITUTE(A1,B1,"") B2 =LEFT(A2,FIND(">",A2)-1) C2 =SUBSTITUTE(A2,B2,"")
Excel tables to the web >> Excel Jeanie HTML 4
HTH, Peter
Please test any code on a copy of your workbook.
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".
Maybe
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"yield",""),"(",""),")","")+0
HTH, Peter
Please test any code on a copy of your workbook.
Sorry, that didn't work. Got a "Value" error
Give some examples of existing values.
HTH, Peter
Please test any code on a copy of your workbook.
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
Like this thread? Share it with others