MS Excel question, please help!
Hi guys, I need your help!
I'm working on this Excel worksheet my associate sent me and I need our IT guy to export it into our accounting system. The problem is, the file gets being rejected because of some invalid characters that are scattered within some cells. I'm talking about those little squares with a question mark in it... does that make sense? They are present in cells that have really long data in it. Our programmer said they're called linefeeds or hard returns and they got copied over from some other data source.
We're trying to figure out how to remove those linefeed characters, and I need it asap! Search and Replace command won't work, it can't find those characters... weird huh!?. We hate to edit those cells one by one, or it's gonna take us maybe a week :(
Can anyone, patulong naman please...!
Thanks!
I'm working on this Excel worksheet my associate sent me and I need our IT guy to export it into our accounting system. The problem is, the file gets being rejected because of some invalid characters that are scattered within some cells. I'm talking about those little squares with a question mark in it... does that make sense? They are present in cells that have really long data in it. Our programmer said they're called linefeeds or hard returns and they got copied over from some other data source.
We're trying to figure out how to remove those linefeed characters, and I need it asap! Search and Replace command won't work, it can't find those characters... weird huh!?. We hate to edit those cells one by one, or it's gonna take us maybe a week :(
Can anyone, patulong naman please...!
Thanks!
Replies to This Discussion
-
Permalink Reply by GM on -
Try using a macro to do a custom 'find and replace' routine. Look for the linefeed character "chr(10)" then replace it with a blank or empty space (""). You're right, just doing the usual find and replace from the Edit menu won't yield those characters.
I hope this helps, goodluck!
-
Permalink Reply by Marisa Laurel on -
Thank you for your suggestion, you're right the search and replace on Edit menu cannot find those characters. I hate to ask, can you tell me more about that macro? I am completely lost in that area. My time is running out.. :-(
-
Permalink Reply by GM on
-
ok i'll give it a shot. try this attached macro. it will remove all linefeeds and hard returns from your worksheet. just select the cells, then run the macro. if you don't know how to use a macro, it's time you call the help of your programmer! ;-)
- Attachments:
-
-
ReplaceLinefeeds.txt, 1 KB
-
-
Permalink Reply by Marisa Laurel on
-
Hi!!! im back.. feel guilty. We were rushing things up at the office so i forgot to post an update here. anyway, Im back home and i just had to take control of the family computer, lol.
The command i downloaded here worked!! thanks gerry thank you thank you thankyou! i saved so much time in my work.
Tahnks again for taking the time responding to my geeky question ha? Mabuhay!
-
Permalink Reply by GM on
-
No worries Marisa, I'm glad it worked for ya. Hey, ganyan talaga dito sa UnitedPhilippines, we help each other ;-)
To others: don't hesitate to ask questions (anything, not just the "geeky" ones he he he). I'm sure our other community members here are eager to extend a hand.
United Philippines - Filipino social network Badge
Spread the word. Get your own United Philippines - Filipino social network badge for your website or MySpace page. (Get Code)
Why is UnitedPhilippines different?
At UnitedPhilippines, we uphold UNITY & RESPONSIBILITY. We aim to unite every Philippine-loving people on all corners of the world.
With that goal, we also carry tremendous responsibility to all our community members here. This website is for the whole family. We are a kids-safe social networking site, and is not inclined to any political side. We don't tolerate racism, hate and especially -- we DO NOT allow pornography.
Unity + Responsibility = UnitedPhilippines.com
Join us, and Spread the word now!
With that goal, we also carry tremendous responsibility to all our community members here. This website is for the whole family. We are a kids-safe social networking site, and is not inclined to any political side. We don't tolerate racism, hate and especially -- we DO NOT allow pornography.
Unity + Responsibility = UnitedPhilippines.com
Join us, and Spread the word now!
© 2008 Created by UnitedPhilippines
