remove some characters from a cell

[leewisener]

I have done this before but I cant seem to get it to work right.

I have around 1000 cells on excel with account numbers in the following format.

102498121/1

All I want to do is simply remove all of the "/1" characters from the end of each account..

Can someone help please.


Lee

 

[gizmo1973]

Text to columns might work if you have all numeric or alpha and then one /
Select / as the seprator

Regards, Phil.

M.U.F.C. Show your true support here:

http://www.shareholdersunited.org/join.php

"Shares not Shirts

 

[pbrodsky]

Why can't you just use find/replace. It worked when I tried it.