Removing Text

[bt707]

I have a long column that has text in it.

Ex:

A1= joe1-g-mex.state.city
A2= bill22-g-mex.state.city
B3= mary-g-mex.state.city

I need to be able to remove everything from the dot (.) to the end
leaving only the first part that is up unto the (.) but not including
the (.)

To make it look like this:

A1= joe1-g-mex
A2= bill22-g-mex
B3= mary-g-mex


Thanks for any help!!!

 

[Bob Phillips]

In B1, put =LEFT(A1,FIND(".",A1)-1)
Copy down
Copy column B
Menu Edit>PasteSpecial - Values
Delet column A

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[RagDyer]

One way is to add a helper column and enter this formula and copy down as
needed:

=LEFT(A1,LEN(A1)-5)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a long column that has text in it.

Ex:

A1= joe1-g-mex.state.city
A2= bill22-g-mex.state.city
B3= mary-g-mex.state.city

I need to be able to remove everything from the dot (.) to the end
leaving only the first part that is up unto the (.) but not including
the (.)

To make it look like this:

A1= joe1-g-mex
A2= bill22-g-mex
B3= mary-g-mex


Thanks for any help!!!

 

[Gord Dibben]

Insert 2 columns next to your Column A

Data>Text to Columns>Delmited with "other" .(dot)

Finish. Delete the columns with state and city.

Gord Dibben XL2002