+ Reply to Thread
Results 1 to 5 of 5

Help Please! Cant understand what is this space in front of values

  1. #1
    Registered User
    Join Date
    10-12-2013
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    5

    Help Please! Cant understand what is this space in front of values

    I got a problem . This morning my last export gave me this. what is this format or character in cells.

    Thanks in advance!

    indent... Anyone can give me a tip how to transfer it into spaces?
    Attached Files Attached Files
    Last edited by dimitrov_dimityr; 10-21-2013 at 06:44 AM.

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Help Please! Cant understand what is this space in front of values

    Hi,

    Go into Format Cells/Alignment and you will see that these cells have been formatted as Left (Indent) with an Indent of 7.

    Amend as suits your requirements.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Help Please! Cant understand what is this space in front of values

    Just Indentation getting applied on those cells.

    Select the range>>Right Click>>Format Cells>>Alignment>>Indent>0>Ok..


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Help Please! Cant understand what is this space in front of values

    welcome to the forum. are you having any problems with it or are you just curious why? select those cells & right-click -> Format Cells -> Alignment. you'll see that Indent is at 7. you can change it to 0 if you want

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  5. #5
    Registered User
    Join Date
    10-12-2013
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Help Please! Cant understand what is this space in front of values

    Thanks all for the fast response. I was getting instead of indent --- spaces
    All my transformations were based on number of the spaces in front of the values.
    I will write something to get the indentvalue and insert spaces depending on it.

    Thanks all!!! You are great

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Insert a space in front of all upper case text
    By excelrod in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2012, 12:02 PM
  2. How to remove a space in the front
    By gurp99 in forum Excel General
    Replies: 12
    Last Post: 01-30-2011, 05:21 PM
  3. How to remove space and symbols in front of words
    By Jeff M in forum Excel General
    Replies: 2
    Last Post: 03-26-2009, 12:56 PM
  4. Macro to delete space in front of date
    By Neutron1871 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-29-2005, 07:06 PM
  5. get rid of space in front of a word
    By CENorth7272 in forum Excel General
    Replies: 2
    Last Post: 02-01-2005, 10:19 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1