Link to home
Start Free TrialLog in
Avatar of baleman2
baleman2

asked on

Replace a character in Excel Spreadsheet cell

I have a Parts List with over 2,000 part numbers - one part number per row and all in Column B.  The format of the part numbers is as follows:     9999-999-999

The software that I need to import the parts list into does not recognize the "-" (hyphen) embedded in the part number.  The part number format that MUST be adhered to in the new software requires a "space" where the "-" (hyphen) is now shown.

So, the newly formatted part number should look like this:      9999 999 999

Is there a way to make this replacement for all part numbers listed in the spreadsheet at one time?
SOLUTION
Avatar of mvidas
mvidas
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of [ fanpages ]
[ fanpages ]
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of baleman2
baleman2

ASKER

Thanks to you both.  I'm splitting the points equally because both solutions essentially gave me the same info and both were correct.
Avatar of [ fanpages ]
[ fanpages ]
No problem at all.  I'm sure Matt won't mind.

Thanks in any respect & good luck with the rest of your project.