Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello!
I have a column with text in cells; the text in each cell contains one, more or no comments. All comments are between {}. I need to find text between { } that exists in a cell, cut it from that cell and paste it in the adiacent cell in the next column. for example, I have the following text in cell A1: "This is {comment1} some example {comment2} text" I need to cut {comment1} and {comment2} from cell A1 and paste them both in cell B1, so that in column A I would only have the text without comments and in column B only the comments. This would need to go on automatically for the whole column. thank you all in advace for any suggestions! AstridC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find text then cut and paste it | Excel Programming | |||
Using IF to find text + wildcard? | Excel Worksheet Functions | |||
Excel custom autofilter- how to find wildcard characters but not as wildcards (e.g. "?") in a cell | Excel Discussion (Misc queries) | |||
select text in cell based on text from another cell, paste the text at the begining of a thrid cell, etc... | Excel Programming | |||
Find wildcard text within a cell | Excel Programming |