Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Removing unwanted characters in Number cells

I converted some PDF bank statements to Numbers using the PDF to Numbers App. However, many of the cells contain hidden characters (in blue) when highlighted by the cursor. I have tried using the paragraph styles function but still can't get rid of them. Would be grateful for some assistance with this. Thank you.


iMac 27″, macOS 10.15

Posted on Jun 16, 2022 3:22 PM

Reply
Question marked as Best answer
  1. Find & Replace (command F)
  2. Click the gear and choose Find & Replace if there is no Replace box
  3. Type \n in the Find box
  4. Leave the Replace box empty
  5. Replace All



Posted on Jun 16, 2022 6:04 PM

3 replies

Removing unwanted characters in Number cells

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.