Removing .zip from cell

  • Thread starter Thread starter myssieh
  • Start date Start date
M

myssieh

I am using office 2007...

I have a column of cells that end in .zip example: me.zip

how can I have excel remove the .zip and leave the me?

thanks for any help in advance.

Myssie
 
I am using office 2007...

I have a column of cells that end in .zip example: me.zip

how can I have excel remove the .zip and leave the me?

thanks for any help in advance.

Myssie
Click to expand...

Cells? Excel?
You have posted this question to the wrong newsgroup.
The access in this groups title refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for the Excel program you are
using.
 
Click on top of column, click the pull down of the 'Find & Select' iconn
select Replace, in the Find What: enter .zip and click Replace
All.
 
Back
Top