Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to copy a part of a cell coming from a Web Query?
Hi friends, I need a very specific help. In my spreadsheet, I've imported data from an external server, which returns the following data in column F: F6: 45/500 F7: 12/50 F8: 222/500 Well, the thing is that I only need the first part of the content, I mean the numbers before the "/" Is there any way to copy only the info before "/" and copying it into column G, for example? I tried with "text in columns" but the update process coming from the web query returns everything to original. Thank you and I hope your appreciated help. Max. *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to copy a part of a cell coming from a Web Query?
hi
a formula might do it in G6 enter.... =LEFT(F6,FIND("/",F6,1)-1) regards FSt1 "max lob" wrote: Hi friends, I need a very specific help. In my spreadsheet, I've imported data from an external server, which returns the following data in column F: F6: 45/500 F7: 12/50 F8: 222/500 Well, the thing is that I only need the first part of the content, I mean the numbers before the "/" Is there any way to copy only the info before "/" and copying it into column G, for example? I tried with "text in columns" but the update process coming from the web query returns everything to original. Thank you and I hope your appreciated help. Max. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy selected part number of text from one cell into another cell | Excel Discussion (Misc queries) | |||
web query doesnt copy the essential part. | Excel Programming | |||
Find and copy part of a cell | Excel Worksheet Functions | |||
How do I copy part of each cell in a column? | Excel Discussion (Misc queries) | |||
Web query - using cell contents as part of URL | Excel Programming |