Removing a forward slash

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone help please?

I have a very long list of numbers each containing a forward slash i.e.
001/1, 002/3 etc

Does anyone know of a formula or macro to remove the slash?

Many thanks
 
Hi Les

Work on a copy of your data - just in case!!!

Use a helper column. Enter the following
=SUBSTITUTE(A1,"/","")
and copy down. Change reference to appropriate column containing the
numbers with the slash.
Then copy the helper column, move cursor to original column and Paste
Special>Values
 
Back
Top