Deleting part of cell data

[thewiseguy]

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"

Thanks in adavance.

twg

 

[JoeMo]

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?

 

[bschwartz]

Maybe:

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

 

[thewiseguy]

Maybe:

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

thank you!

 

[bschwartz]

You're welcome.

 

[galt13]

Assuming that your value is in range A1

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

 

[Rick Rothstein]

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)

 

[bschwartz]

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"

Thanks in adavance.

twg