Deleting text from a column

  • Thread starter Thread starter bt707
  • Start date Start date
B

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!!!
 
If you want to delete everything right of the first dot,
and all cells have at least one dot.

=LEFT(A1,FIND(".",A1)-1)
If text is in cell A1
 
First back up your data, and then select all your data and do Data / Text To Columns / Delimited /
Put a full stop in the other field and tick other, and now click on each of the columns past the
first and choose the 'Do Not Import' option. Then hit OK
 
Back
Top