| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match function
I'm using the Match function & I'm having trouble because I'm copying info
from a web page & pasting it into my Excel - when I paste it - it's actually a link to the web page...so my function will not work. How do I convert the data so it will work - I've looked at reformating but haven't had any luck. I can't use excel's find feature because the data is too long. That would have been easiest... Any ideas? Regards |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match function
When you paste in the data, can you do a Paste special - Values?
If your needing the links, another option might be to use the VALUE function. -- Best Regards, Luke M "markholt" wrote: I'm using the Match function & I'm having trouble because I'm copying info from a web page & pasting it into my Excel - when I paste it - it's actually a link to the web page...so my function will not work. How do I convert the data so it will work - I've looked at reformating but haven't had any luck. I can't use excel's find feature because the data is too long. That would have been easiest... Any ideas? Regards |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match function
THANK YOU !!!
I never used the paste special... Regards, Mark "markholt" wrote: I'm using the Match function & I'm having trouble because I'm copying info from a web page & pasting it into my Excel - when I paste it - it's actually a link to the web page...so my function will not work. How do I convert the data so it will work - I've looked at reformating but haven't had any luck. I can't use excel's find feature because the data is too long. That would have been easiest... Any ideas? Regards |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match function
Glad I could help, and thanks for the feedback.
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "markholt" wrote: THANK YOU !!! I never used the paste special... Regards, Mark "markholt" wrote: I'm using the Match function & I'm having trouble because I'm copying info from a web page & pasting it into my Excel - when I paste it - it's actually a link to the web page...so my function will not work. How do I convert the data so it will work - I've looked at reformating but haven't had any luck. I can't use excel's find feature because the data is too long. That would have been easiest... Any ideas? Regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Match as well as does not match array function | Excel Discussion (Misc queries) | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Linear Mode
