I need a macro to take away data from my spreadsheet. The spreadsheet i
created from data i have emailed to me from a form on my website.

For example, each set of cells would have something like this with eac
line in each cell

F_name: John Smith
Unit: Computer Tech
Comments: blah blah blah

I would like the macro to take away the "F_name:, Unit:, and Comments:
text leaving only the valuable information that i can then make a goo
informative sheet with.

I am an experienced excel user so if you have any ideas please let m
know.

Thank

--
s_tyron
-----------------------------------------------------------------------
s_tyrone's Profile: http://www.excelforum.com/member.php...fo&userid=2751
View this thread: http://www.excelforum.com/showthread.php?threadid=47021