Say your range to fix is in A1:A999
Put that formula in B1 and drag down to B999
(excel will adjust the formula for you for each cell)

Debra Dalgleish goes into more detail he
http://contextures.com/xlDataEntry01.html

This was my original suggestion:

I'd insert a helper column to the right of your column.

Then use a formula like this:
=IF(COUNTIF(A1,"*/*")=0,"/","")&A1

Then drag this formula down the column.

Then select that new column
edit|copy
edit|paste special|values

And do data|text to columns against this helper column.

And delete the stuff you don't need when you're done.

======
When you have trouble understanding a suggestion, it's usually lots better to
respond within the same thread. The people will know what was suggested and
what you tried without having to guess.

And it's better to post to just one newsgroup. Then you only have to go to that
one newsgroup to find all the suggestions.

Debrap29 wrote:

Dave:

I had gotten a few answers and tried just about all of them. Not sure
which one you sent. The problem is I am EXTREMELY new to Excel, so I
believe what you had told me helped for one cell, but not the entire
column and since I am so new to Excel, I am not sure how to work the
formula you gave me to do that.

Thanks.

--
Debrap29
------------------------------------------------------------------------
Debrap29's Profile: http://www.excelforum.com/member.php...o&userid=36127
View this thread: http://www.excelforum.com/showthread...hreadid=559982

--

Dave Peterson