Hi,
My Search formula is not working due to an automatic "Enter" in the downloaded file from a database as per below;
PMDS Service Code Data for:
Toyota
How do I remove that, so that the Search formula works.
Appreciate the help
Hi,
My Search formula is not working due to an automatic "Enter" in the downloaded file from a database as per below;
PMDS Service Code Data for:
Toyota
How do I remove that, so that the Search formula works.
Appreciate the help
Is that on a separate row, or in the same cell?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry, same cell
Can anyone help?
Thanks,
Try this...
=SUBSTITUTE(A1,CHAR(10),"")
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Cheers mate. Thanks for the help.
Glad it helps you and thanks for the feedback and rep
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks