Hi and welcome to JustAnswer. My name is XXXXX XXXXX X will be your expert tonight.
Are you looking to remove just spanish characters, or spanish words as well?
are you there
I have a excel spreadsheet with the characters in the Company Name and in the address and i need to get them out
Are they the same characters throughout?
DESPAL PAULISTA AGRONEGÓCIOS BIOENERGIA LTDA 55 17 3551 1340 AV. FELIX HAFFID JOSE GATTAZ, 454 CENTRO IBIRÁ São PauloEngetech Comércio e Indústria de Plásticos ltda 55 21 3295 8800 Estrada Municipal São João caxias i 1640 City - State: São João de Meriti - Rio de Janeiro pq
that is a sample
Hmm, there won't be an easy way to remove all of that throughout the excel.
We could remove individual characters, converting AGRONEGÓCIOS to AGRONEGCIOS
Would that work?
are they the same word
And some of these words will not have an English equivalent without the spanish characters.
can you not just chage
change the spreadsheet from spanish to english
Unfortunately not as the characters are set within Windows and changing it will only prevent additional spanish characters from being entered.
then i guess you do not have a answer
I do, but there isn't an automatic solution.
The best we can do is remove the characters themselves, but the word won't be the same anymore
What I think you're looking to do is translate it.
And any application that will translate it for you will not get it perfect and can still leave some spanish characters behind.
well i already know i can do it one at a time but this i a very large database and cannot be done
If you're only interested in removing the characters, you can do a search and replace for each character (I believe there is only about 6 unique spanish characters) and remove them all from the spreadsheet.
Would that be acceptable for you?
would the address be correct
There is no way to have the address correct without the spanish characters.
If you change it, you leave the address open to interpretation and someone would have to guess what it is suppose to be.
well i need the company name and the address to be correct
sorry to have wasted your time
You can save the company name and address in another sheet, do the find and replace, then return the name and address.
Not a waste at all if we're able to work out an acceptable solution :)
i dont understand that
We'll preserve the company name and address by copying it somewhere else.
Then, you can search and replace all spanish characters to remove them.
Once removed, you copy the name and address back and they will be the only spanish characters.
then will the address be ok
what do you mean they will be the only spanish characters
If we do a search and replace on the rest of the document, we can delete the remaining spanish characters.
ok how do i do that
Go ahead and copy and paste the name and address to another excel document.
can i just paste the whole document into another sheet
But you will have to paste the name and address back when we're done.
If you like, you can attach the document here and I can make these changes for you.
how do i do that
Go to this website and upload the Excel file. Remember, anything posted here will be available for everyone who knows how to see.
ok i dragged it there now what
You should have a link to it now.
Paste it here so I can download it.
I already sent it and i will leave it with you and leave my computer up...i have an appointment and i will not be back until 8:00 eastern time
I do not see the link.
i dragged it into where they said to
pastelink.me/dl/abdac2 was i suppose to paste this here
I will go ahead and make these changes and upload the revised version.
Please feel free to rate my service when you are satisfied.
Here is the new version.
Please let me know if there is anything you would like me to do to it.
Once you are satisfied, please remember to rate my service.
Not quite what i was looking for