Copying data in Board Tables adding CODE(63) to end of every cell

jdellasala

Well-known Member
Joined
Dec 11, 2020
Messages
751
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
  3. Web
I first ran into this a day or two ago. I copied data from a post that included a BB Board table like this:
Column AColumn BColumn C
112/18/2022Grapes
20312/17/2022Oranges
When I pulled the data into Excel by a simple Copy/Paste (match destination), the data LOOKED ok although numeric data was left justified, but no matter what I did I was unable to convert numeric data like in columns A and B above into numbers. It happened again today, so I investigated further.
It ends up that what should be a completely visible question mark is appended to the end of every cell, so that the second row in Column A above comes in with a LEN() of 2 instead of 1, but the second character is invisible.
When I looked at the CODE() value of each character in the cell, the second character CODE was 63 which SHOULD be a simple question mark.
The easiest way I found to convert the value to a number was to use
Excel Formula:
=NUMBERVALUE(LEFT(A2,LEN(A2)-1))
Is this a Board issue, or something that Microsoft needs to address?
 
Last edited by a moderator:
It's not code 63 it's unicode 8203 & I think it's soemthing to do with Xenforo. I tend to clean the data with a macro.
 

Forum statistics

Threads
1,216,725
Messages
6,132,342
Members
449,719
Latest member
excel4mac

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top