Hi I have the follwoig spreadsheet (see attached) the values within it I believe are numbers stored as text, I cannot seem to convert the values into numbers. Can anyone assist?
Hi I have the follwoig spreadsheet (see attached) the values within it I believe are numbers stored as text, I cannot seem to convert the values into numbers. Can anyone assist?
Edit:
I noticed that all your numbers start from position 3. In that case, you can use =RIGHT(A2,LEN(A2)-2) formula to extract the numeric values.
Your data has an encoding issue. Save your Excel worksheet as a CSV File, close and reopen the CSV file. Then use substitute function to remove the unwanted characters.
Last edited by JieJenn; 08-09-2021 at 09:42 AM. Reason: better solution
if a one-off exercise, one option...
enter: =LEFT(A2) in B1, copy B1, highlight column A, Edit -> Replace... paste the copied value into "Find What" (will appear blank) and leave "Replace With" empty, then hit Replace All
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks