We have a client's data file in Excel 2003 that has carriage returns (displayed as tiny boxes) appearing in the cells. We want to be able to remove these characters, but keep the rest of the text.
Can anyone help?
I would cmd-F in a decent programme and enter what the characters display as, then whack delete. Dreamweaver would do it, just export the file to text first.
Thank you for your quick response, Kip. I'll pass that onto my IT guy. Holborn Direct Mail 020 8683 7155
If you still haven't cracked it. Ctrl A, Ctrl C your data from your spread sheet paste it into notepad (not word pad) Ctrl H (find & replace) you can cleanse any duff data, then copy and paste back into your spreadsheet.
Thank you so much, Steve. That seems to do the trick.  Holborn Direct Mail 020 8683 7155 |
Recent Posts AI is the future of technology? 2 comments Best Platform for Azure Certified Professionals?  2005 - 2022 the rise and fall of mobile traffic - and why 4 comments Office security 1 comments Scheduling meetings - Acuity nails it! Which Freelance Website is best for Pick the Project? 5 comments Wordpress alternative 6 comments  Email checker - see if your email has been compromised 14 comments Anyone used Wix? 24 comments Business Websites... 3 comments I Dont Need a Website...!  Massachusetts Institute Of Technology Anyone used EMERGE App? 1 comments  Krack Attacks - WiFi Issue - The realistic risk to you 7 comments  Opening Outlook attachments prompt for a password 4 comments |
