I have a solution - I know it's about a year and half late for you, but I noticed this thread has been read over 3000 times, so I figured I'd post a solution anyway. I had the same problem this morning.
The way to remove those pesky characters in excel is to do the following:
With your data in excel, add a column to the right of your data and populate the rows with a string that won't appear in your real data (I use very foul swear words for this).
Save your spreadsheet as a text file (CSV or Tab delineated).
Open this text file in word, and use the search/replace function replace ^p with a space (or whatever)
Then search and replace your unique string (or foul swear word) with ^p
Save your text file and close it.
Open it in excel and behold the wonders
The way to remove those pesky characters in excel is to do the following:
With your data in excel, add a column to the right of your data and populate the rows with a string that won't appear in your real data (I use very foul swear words for this).
Save your spreadsheet as a text file (CSV or Tab delineated).
Open this text file in word, and use the search/replace function replace ^p with a space (or whatever)
Then search and replace your unique string (or foul swear word) with ^p
Save your text file and close it.
Open it in excel and behold the wonders
Hi all, First time post, hope someone can help.
I have had to develop a contact database for about 10-15 users that currently have approx 2000 - 3000 contacts each.
I have built an Access DB and imported some of the existing data, but the original format of data that I need to import is Excel and when imported into the Access 97 table, it retains the carriage returns (from Excel) and represents them as a square (In the Access table). I need to replace the carriage return with a comma or a space. Is there any way that I can make a query that will remove or replace a carriage return??
Sample data: OPTILU2008TU
I have tried to simply search for UniCode Alt+0129, but no good.
I have had to develop a contact database for about 10-15 users that currently have approx 2000 - 3000 contacts each.
I have built an Access DB and imported some of the existing data, but the original format of data that I need to import is Excel and when imported into the Access 97 table, it retains the carriage returns (from Excel) and represents them as a square (In the Access table). I need to replace the carriage return with a comma or a space. Is there any way that I can make a query that will remove or replace a carriage return??
Sample data: OPTILU2008TU
I have tried to simply search for UniCode Alt+0129, but no good.
