Excel 1

[rhull]

What I need to do is add a ':'in every cell at the end of the data. (I need to export the data with a delimiter).
Any ideas?

Thanks!
-Ryan

 

[Dreamboat]

Suppose your data is in A2. Just put:

=a2&":"

into B2.

When you're done, you'll have to copy the new cells and hit Edit-Paste special-Values to get rid of the underlying formula.

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

 

[Dreamboat]

PS: If you just open the file in Word, it should open as a table. You can click inside a cell, hit Table-Select table and then choose Table-Convert table to text and type a colon in the delimiter field.

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

 

[rhull]

I used the second option with Word and that worked pretty slick. I never would have come up with.
Thanks!

-ryan