Hello everyone,

Is there an easy way to insert dashes (-) into existing data. For
example, I want to insert dashes into the following data 123456789, I
want it to look like this, 123456-78-9. I have many records to do this
to, so any help is much appreciated.

Thanks.


--
mes44
------------------------------------------------------------------------
mes44's Profile: http://www.excelforum.com/member.php...o&userid=28183
View this thread: http://www.excelforum.com/showthread...hreadid=477128