Excel text manipulation rocks Jun28 '05

# (1 of 3): Ed

1 year, 6 months after the fact. (Sun 14 Jan 2007, 3:26 PM CST)

I use this frequently at work, but really what I want to do is be able to do remove unwanted characters all in one go. The way I do that is usually using lots of composed substitute functions. Likewise I'd also like to be able to do a split function call to deal with comma separated code in one easy function call.

# (2 of 3): Sue Rockwell

2 years, 9 months after the fact. (Wed 16 Apr 2008, 10:16 AM CST)

I just used the =PROPER feature in excel and I loved it. The file I had to use was typed in all caps and it would have taken me forever to retype all the information. Thank you so much for the valuable information I really REALLY appreciate it!

Previous comment Return to entry

# (3 of 3): Joe

3 years after the fact. (Thu 17 Jul 2008, 9:32 AM CST)

Thanks!!! This just saved me three hours of tedious work. Thanks for posting.

-Joe- Web Designer - Detroit, MI

Previous comment Return to entry