data
4 replies
Sample discussion: Website se copy kiye fictional product names par TRIM lagaya, phir bhi kuch lookups match nahi ho rahe. Kya check karna chahiye?
Copied text may contain non-breaking spaces. For that specific character, try: =TRIM(SUBSTITUTE(A2,CHAR(160)," ")) This replaces character 160 with an ordinary space, then trims. Other Unicode spacing characters need separate checks.
Original column ko preserve karein aur helper column mein cleaned value check karein. TRIM also reduces repeated internal spaces, so make sure that is appropriate for your data.
That fixed this practice example. Aapke imported data mein aur kaunse unusual characters milte hain?