You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Removing a double space before characters in a cell

Removing a double space before characters in a cell

Price: FREE

I have an excel spread sheet with over 700 rows of data on (only 3 columns).
For some reason, some 3500 of the key cells have a double space prior to the character which in turn is affecting the a-z sorting of the data. Excel is assuming that the double slipcase is a character and sorting them differently to the rest of the sheet.
Without manually going through the 3500 cells and deleting the double space, does anyone know how I can remove the double space before the characters so that it sorts correctly?
(I've tried left and right align but it doesn't change the way it sorts.)

Visit publisher's web-site: Removing a double space before characters in a cell

Category and Tags: ExcelTutorials :

Related Tutorials

Removing all characters to the right of the last space in a cell

Free: Yes
Tags: Excel ›

if the data string in each cell is not uniform
Michael Malone /J
Ben hammer OddF
in the above example I am wishing to remove the characters in bold, what they have in common is they are the characters to the right of the last space in the string.

Conditional formatting double space intermittently working

Free: Yes
Tags: Excel ›

I have 2010
I have conditional formatting that looks for special characters that are listed on another sheet and fills color so the data entry person knows there are special characters that aren't allowed. We also look for double spaces.
Conditional formatting formula:
=SUM(--(ISNUMBER(FIND('Special Characters'!$B$2:$B$168,A2))
It catches some double spacing where ever it exists in a paragraph. Other times in other cells it doesn't. If I just enter a double space into a cell where it DIDN'T catch it in a paragraph, it catches it.

removing/extracting characters from a string

Free: Yes
Tags: Excel ›

if someone could show me a way to remove the first 3 characters (including a space between them) from a string. Also, is there a way (in a separate formula) to do the opposite and remove all the values with the exception of these first 3 characters?
I've attached a sample calc and would be grateful for any advice on this.

Removing a space at the start of a cell...

Free: Yes
Tags: Excel ›

I have a huge column of names in my spreadsheet which I've imported, they all have a single space at the start of the cell and then the name. Is there any way I can remove this space so that all the names start at the beginning of the cell instead of one space into it?

Removing space in a cell

Free: Yes
Tags: Excel ›

How can I cut space in a cell ? For instance in A1 I have ZW34 00 76, I want it to be

Related Applications & Scripts

Erase Disk Free Space Script

Free: Yes
Tags: Software › Excel Security

Use this script to erase all the free space on your disk drive by filling it with blank, zeroed files. The WSF script runs on Windows and is freeware licensed under GPL. Just copy it to the drive you want to fill up, and double-click on it.

Double click script (AS 2.0)

Free: No
Tags: Flash › Excel Buttons

The Double click script (as2.0) is, as the name is saying, the script for double click button.

Text in Space Intro

Free: No
Tags: Flash › Excel Text Effects

Create a dynamic movie like intro for your brand. Text flying in space and zooming in. Totally random placement. Very easy to use.

Speed up Ajax using JSMin in JavaScript

Free: Yes

Basically, this application removes all the white spaces in the application. These spaces are very small but since they are constantly seen in a website, they drag the processing of the function located in the coding of the application. By removing the white spaces, JSMin enables the developers to hasten the speed of their website or any application.
Aside from removing whitespaces in the coding of the application, JSMin also changes some characters in the coding also with the purpose of hastening the processing of the functions in the application. It will also change some of the things it sees unfit.

Random Characters Text Effect

Free: No
Tags: Flash › Excel Text Animation

Random Characters Text Effect features the cool text effect with random characters forming your text. However, this version is on steroids allowing you to use cool glow and blur effects when wanted! Furthermore, this effect really is extremely easy to implement in ANY Flash project (AS 2.0) without it interfering with the existing Flash project itself. You might therefore implement it in other files from FlashDen to spice things up a little!

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing