| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I find a string with or without a space after the last charact
I have a word in a Cell. I copy it in " Find". I Search in another Sheet that
word. If I have extra spaces before or after it I can not find it often it exists. The word changed. I tried to write a macro but it doesnt work. Can helps me someone? Thanks millions. Emil |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I find a string with or without a space after the last charact
Try setting the Lookin value to xlPart in the Find statement.
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "emil" wrote in message ... I have a word in a Cell. I copy it in " Find". I Search in another Sheet that word. If I have extra spaces before or after it I can not find it often it exists. The word changed. I tried to write a macro but it doesn't work. Can helps me someone? Thanks millions. Emil |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I find a string with or without a space after the last charact
not a very high tech way but ...... the find command so long as the 'match entire contents' box is not ticked would not worry about the spaces. eg if your cell you are copying is 'test ' on the other sheet if you search for 'test' it should find all instances regardless of spaces. also you have the chance to use the TRIM command, as it will strip the spaces off the end of cells. one thing to watch out for is if the second sheet you are looking on has the word as the result of a formula as sometimes it searches the formula code and not the results -- lister_d_000169 ------------------------------------------------------------------------ lister_d_000169's Profile: http://www.excelforum.com/member.php...o&userid=32950 View this thread: http://www.excelforum.com/showthread...hreadid=548349 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I find a string with or without a space after the last cha
Thank very much, but I want to write a macro
"Bob Phillips" a scris: Try setting the Lookin value to xlPart in the Find statement. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "emil" wrote in message ... I have a word in a Cell. I copy it in " Find". I Search in another Sheet that word. If I have extra spaces before or after it I can not find it often it exists. The word changed. I tried to write a macro but it doesn't work. Can helps me someone? Thanks millions. Emil |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I find a string with or without a space after the last cha
Thank very mach, I shall try this Emil "lister_d_000169" a scris: not a very high tech way but ...... the find command so long as the 'match entire contents' box is not ticked would not worry about the spaces. eg if your cell you are copying is 'test ' on the other sheet if you search for 'test' it should find all instances regardless of spaces. also you have the chance to use the TRIM command, as it will strip the spaces off the end of cells. one thing to watch out for is if the second sheet you are looking on has the word as the result of a formula as sometimes it searches the formula code and not the results -- lister_d_000169 ------------------------------------------------------------------------ lister_d_000169's Profile: http://www.excelforum.com/member.php...o&userid=32950 View this thread: http://www.excelforum.com/showthread...hreadid=548349 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I find a string with or without a space after the last cha
TRIM is very good
Thank very mach Emil "emil" a scris: Thank very mach, I shall try this Emil "lister_d_000169" a scris: not a very high tech way but ...... the find command so long as the 'match entire contents' box is not ticked would not worry about the spaces. eg if your cell you are copying is 'test ' on the other sheet if you search for 'test' it should find all instances regardless of spaces. also you have the chance to use the TRIM command, as it will strip the spaces off the end of cells. one thing to watch out for is if the second sheet you are looking on has the word as the result of a formula as sometimes it searches the formula code and not the results -- lister_d_000169 ------------------------------------------------------------------------ lister_d_000169's Profile: http://www.excelforum.com/member.php...o&userid=32950 View this thread: http://www.excelforum.com/showthread...hreadid=548349 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of space in a string | Excel Discussion (Misc queries) | |||
| How do i get the last position of a char (space) in a string? | Excel Worksheet Functions | |||
| NEED HELP-----Removing a space at the end of a string of character | Excel Discussion (Misc queries) | |||
| erase all space characters into string | Excel Programming | |||
| Replace Space charcter in a string variable | Excel Programming | |||
Linear Mode
