Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a string in excel
Hi,
I have a txt list that looks likes this: Name: Dave Foo Address: 80 address street Phone: &# Weight: 190 Height: 6 Name: Blab Boing Address: 320 Sycamore Phone: &# Weight: 300 Height: 4 This is repeated for each person and list is 1000 entries long, let's say. I'd like to remove everything in the list except for the address. Or find the address and paste it onto another worksheet, or save it as txt. I just need to isolate the address. Not sure how to do that. Thanks for any help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how we find specific word from string in excel and compaire it. | Excel Worksheet Functions | |||
Find String in another string - only between spaces | Excel Worksheet Functions | |||
Find Many String options in ONE String | Excel Worksheet Functions | |||
Excel -find records which DO NOT contain a particular text string | Excel Discussion (Misc queries) | |||
Excel - Find & Replace text in a string | Excel Worksheet Functions |