| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I delete all text before or after a symbol?
I have columns populated as follows:
variable length characters = variable length characters for example, TVPosPctSP = 0.00 percent I want to copy the entire column, then in the 1st column delete all of the characters in each cell that precede the equal sign, and in the second column delete all of the characters in each cell that follow the equal sign. (and I can include the equal sign in one of those passes) is there a wildcard character that identifies everything before an associated parameter, such as the equal sign? (or everything after an associated parameter, such as the equal sign?) thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I delete all text before or after a symbol?
If info is in column A
column B =LEFT(A1,FIND("=",A1)) column C =RIGHT(A1,FIND("=",A1)) -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Tony" wrote: I have columns populated as follows: variable length characters = variable length characters for example, TVPosPctSP = 0.00 percent I want to copy the entire column, then in the 1st column delete all of the characters in each cell that precede the equal sign, and in the second column delete all of the characters in each cell that follow the equal sign. (and I can include the equal sign in one of those passes) is there a wildcard character that identifies everything before an associated parameter, such as the equal sign? (or everything after an associated parameter, such as the equal sign?) thank you |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I delete all text before or after a symbol?
Excellent ! Thank you John. That just saved me alot of keystrokes.
appreciate the answer. "Tony" wrote: I have columns populated as follows: variable length characters = variable length characters for example, TVPosPctSP = 0.00 percent I want to copy the entire column, then in the 1st column delete all of the characters in each cell that precede the equal sign, and in the second column delete all of the characters in each cell that follow the equal sign. (and I can include the equal sign in one of those passes) is there a wildcard character that identifies everything before an associated parameter, such as the equal sign? (or everything after an associated parameter, such as the equal sign?) thank you |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I delete all text before or after a symbol?
Hello John,
After reading your message, I decided to try your code as a replacement for my REPLACE code. I am separating "QUANTITY: X". X is a variable integer between 1 and 100. My goal is to extract the quantity as a number. When I try your code, column B results in "QUANTITY:" as expected. Column C results in: when X = 1-9: ANTITY: X 10-99: NTITY: X 100: TITY: X I don't understand the results I am getting and was wondering if you might possibly know. Is the colon the problem? I tried a space between the quotes and that gave even more unexpected results. I would appreciate your feedback, Thanks, Alan "John Bundy" (remove) wrote in message ... If info is in column A column B =LEFT(A1,FIND("=",A1)) column C =RIGHT(A1,FIND("=",A1)) -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Tony" wrote: I have columns populated as follows: variable length characters = variable length characters for example, TVPosPctSP = 0.00 percent I want to copy the entire column, then in the 1st column delete all of the characters in each cell that precede the equal sign, and in the second column delete all of the characters in each cell that follow the equal sign. (and I can include the equal sign in one of those passes) is there a wildcard character that identifies everything before an associated parameter, such as the equal sign? (or everything after an associated parameter, such as the equal sign?) thank you |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I delete all text before or after a symbol?
The left is easy and straightforward, right is a little tougher, you need to
subtract the length =RIGHT(A16,LEN(A16)-FIND(" ",A16)) this finds the blank before the number, or you could do this =RIGHT(A16,LEN(A16)-FIND(":",A16)) -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Alan" wrote: Hello John, After reading your message, I decided to try your code as a replacement for my REPLACE code. I am separating "QUANTITY: X". X is a variable integer between 1 and 100. My goal is to extract the quantity as a number. When I try your code, column B results in "QUANTITY:" as expected. Column C results in: when X = 1-9: ANTITY: X 10-99: NTITY: X 100: TITY: X I don't understand the results I am getting and was wondering if you might possibly know. Is the colon the problem? I tried a space between the quotes and that gave even more unexpected results. I would appreciate your feedback, Thanks, Alan "John Bundy" (remove) wrote in message ... If info is in column A column B =LEFT(A1,FIND("=",A1)) column C =RIGHT(A1,FIND("=",A1)) -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Tony" wrote: I have columns populated as follows: variable length characters = variable length characters for example, TVPosPctSP = 0.00 percent I want to copy the entire column, then in the 1st column delete all of the characters in each cell that precede the equal sign, and in the second column delete all of the characters in each cell that follow the equal sign. (and I can include the equal sign in one of those passes) is there a wildcard character that identifies everything before an associated parameter, such as the equal sign? (or everything after an associated parameter, such as the equal sign?) thank you |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I delete all text before or after a symbol?
Thanks John,
I need to read up on LEN. Alan "John Bundy" (remove) wrote in message ... The left is easy and straightforward, right is a little tougher, you need to subtract the length =RIGHT(A16,LEN(A16)-FIND(" ",A16)) this finds the blank before the number, or you could do this =RIGHT(A16,LEN(A16)-FIND(":",A16)) -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Alan" wrote: Hello John, After reading your message, I decided to try your code as a replacement for my REPLACE code. I am separating "QUANTITY: X". X is a variable integer between 1 and 100. My goal is to extract the quantity as a number. When I try your code, column B results in "QUANTITY:" as expected. Column C results in: when X = 1-9: ANTITY: X 10-99: NTITY: X 100: TITY: X I don't understand the results I am getting and was wondering if you might possibly know. Is the colon the problem? I tried a space between the quotes and that gave even more unexpected results. I would appreciate your feedback, Thanks, Alan "John Bundy" (remove) wrote in message ... If info is in column A column B =LEFT(A1,FIND("=",A1)) column C =RIGHT(A1,FIND("=",A1)) -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Tony" wrote: I have columns populated as follows: variable length characters = variable length characters for example, TVPosPctSP = 0.00 percent I want to copy the entire column, then in the 1st column delete all of the characters in each cell that precede the equal sign, and in the second column delete all of the characters in each cell that follow the equal sign. (and I can include the equal sign in one of those passes) is there a wildcard character that identifies everything before an associated parameter, such as the equal sign? (or everything after an associated parameter, such as the equal sign?) thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete the actual symbol * | Excel Discussion (Misc queries) | |||
| USING EXCEL, delete all text right of the "!" symbol | Excel Worksheet Functions | |||
| how to delete automatic 'copyright' symbol insertion | Excel Discussion (Misc queries) | |||
| Can I Delete Symbol in Cell That Has A Formula? | Excel Discussion (Misc queries) | |||
| Triangle symbol in cell. What does it mean. How do I delete this | New Users to Excel | |||
Linear Mode
