I have to do some calculations on excel but am getting an error as one of my rows which has dollar values is not properly aligned. There is a space between the dollar sign and the number meaning $ 5 whereas I need it without space like $5. I have over 700 cells where I need to do this. I know I can do this manually but can it be done more quickly within a few seconds or so.
Edit: Title should be Microsoft Excel doubt
If its an actual space between $ and the following figure, then do this:
hit ctrl + H
in the find what dialog, enter $ sign followed by space
in the replace with dialog, only enter $ sign
click the replace all button
Copyright © 2017 HubPages Inc. and respective owners.
Other product and company names shown may be trademarks of their respective owners.
HubPages® is a registered Service Mark of HubPages, Inc.
HubPages and Hubbers (authors) may earn revenue on this page based on affiliate relationships and advertisements with partners including Amazon, Google, and others.