How to remove forward slash (/) from a series of numbers

[bumper717]

I have an excel sheet and one column has a series of numbers that make up a barcode for a particular product. My problem is that each of these barcode numbers has forward slashes within them (eg: 123/45/678/910). In order for me to process the numbers I need to remove these characters as my software program cannot process them. I have in total around 23000 of these numbers so Im after advise for a formulae to fix the issue. Can anyone help?

 

[mole999]

if you had a helper cell then you could =substitute(cell,"/","") or a space " "

that could be written as a FIND REPLACE and recorded in VBA, thats the quickest way to start, without even using VBA

 

[bumper717]

if you had a helper cell then you could =substitute(cell,"/","") or a space " "

that could be written as a FIND REPLACE and recorded in VBA, thats the quickest way to start, without even using VBA

Thanks for the reply and info. I should have mentioned that when it comes to excel I really need spoon feeding! Can you possibly give me some steps for dummies on this?

 

[Peter_SSs]

Thanks for the reply and info. I should have mentioned that when it comes to excel I really need spoon feeding! Can you possibly give me some steps for dummies on this?

Try this.
Select the column by clicking its heading label
Press Ctrl+H (to bring up the Find & Replace dialog)
Find what: /
Replace with: leave blank
Options>>
Make sure 'Match entire cell contents' is NOT checked
Replace All
OK


BTW, Welcome to the MrExcel board!

 

[bumper717]

Thank you Peter, that worked! I knew there must be a way.
Craig

 

[Peter_SSs]

Thank you Peter, that worked! I knew there must be a way.
Craig

Cheers, glad it worked for you
Thanks for letting us know.