Deleting unwanted parts of a line

Copper Contributor

I have an address list, name, address, phone number. I want to keep just the name. The non-name part of the line begins with a digit. I wish I could find that first digit, and delete the rest of the line. 

I appreciate any help.

3 Replies

@michaeltrombetta If you upload a copy of the document, we will take a look at the issue and give you a way to achieve it.

The file is an address list. A typical line looks like this:
Smith, John & Mary, 457 Park Avenue, New York, 212-345-6789
I want to extract just the first and last name part, so I'd like to find the first digit, and delete everything beyond that.
The file is only about 60 lines, so I could do it manually, but I proposed it as a interesting question.
Thank you for your help.

@michaeltrombetta 

Select all of the text and then from the Insert>Table dropdown, click on Convert Text to Table

Doug_Robbins_Word_MVP_0-1719578584871.png

and, then, in nthe Convert Text to Table dialog, select Commas in the Separate text at section and click on OK

Doug_Robbins_Word_MVP_1-1719578778458.png

Then, delete the unwanted columns from the resulting table

Doug_Robbins_Word_MVP_2-1719578826370.png