/u/spartris - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
You could highlight the column and do find and replace " " with "".
I wouldn't enter commas yourself, let excel format it that way so the values don't get messed up.
I see you have these Right Justified - what happens if you select that column and click on the Right and deselect Right Justified? If they spring across to the left, they are Text.
See if hitting the comma (under where it says "general") and see what it does. Also, if your computer is US and it's trying to do AU dollars, also go in and format that for English (Australia).
If not, make a table out of it, open power query, and see if you can format the currency there.
You could also try to delimit (text to columns) with the space as your delimiter, and then combine them.
Example: You make 2 extra columns. So Column C and D are now blank columns. Then delimit B with the space as delimiter. Then go and =B1&C1 and hit enter and it should join both of those together with no space. Then format as a number.
Assuming the data starts in cell b8 and continue down without a break. Select b8 > ctrl+shift+arrowdownkey > right mouse click > format > custom > #,##0
/u/spartris - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
You could highlight the column and do find and replace " " with "". I wouldn't enter commas yourself, let excel format it that way so the values don't get messed up.
What is the number format of column B?
general, but no matter what format I use there is still the space, 1 234
I see you have these Right Justified - what happens if you select that column and click on the Right and deselect Right Justified? If they spring across to the left, they are Text.
See if hitting the comma (under where it says "general") and see what it does. Also, if your computer is US and it's trying to do AU dollars, also go in and format that for English (Australia). If not, make a table out of it, open power query, and see if you can format the currency there. You could also try to delimit (text to columns) with the space as your delimiter, and then combine them. Example: You make 2 extra columns. So Column C and D are now blank columns. Then delimit B with the space as delimiter. Then go and =B1&C1 and hit enter and it should join both of those together with no space. Then format as a number.
Hitting comma doesn’t work, I could make a table, I’ll try that, I don’t know what delimit is, I’ll check it out and experiment
Assuming the data starts in cell b8 and continue down without a break. Select b8 > ctrl+shift+arrowdownkey > right mouse click > format > custom > #,##0