# Deleting part of cell data

#### thewiseguy

##### Well-known Member
Hello again,

Out of this data:

(201) 868-9500 6.65 mile

I would like to delete the "6.65 mile"

so that the data reads " (201) 868-9500"

twg

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
In general, do your data always begin with a phone number (including area code in parentheses) and you want to extract only the phone number?

Maybe:

=REPLACE(A4,15,99,"")

You're welcome.

Assuming that your value is in range A1

=TRIM(LEFT(A1,FIND(" ",A1,7)))

Maybe:

=REPLACE(A4,15,99,"")

If you are going to assume the first 14 characters are uniformly the telephone number, then I would think the following would be a more direct solution...

=LEFT(A1,14)

If you are going to assume the first 14 characters are uniformly the telephone number, then I would think the following would be a more direct solution...

=LEFT(A1,14)

Definitely correct! I guess I saw this, and got that idea in my mind:

Hello again,

Out of this data:

(201) 868-9500 6.65 mile

I would like to delete the "6.65 mile"

so that the data reads " (201) 868-9500"

twg

Replies
12
Views
411
Replies
7
Views
2K
Replies
0
Views
241
Replies
11
Views
1K
Replies
10
Views
666

1,196,268
Messages
6,014,344
Members
441,816
Latest member
Klingon1960

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back