Debrap29,
To add the "/" at the beginning when it is not found you could use
this.
=IF(ISNUMBER(FIND("/",A1,1)),A1,"/"&A1)
Copy down as needed. Then copy the result of your formulas and Paste
SpecialValues over your new text. Then you can use Text to Columns
with the "/" as the delimiter.
HTH
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=559006