+ Reply to Thread
Results 1 to 22 of 22

Extra space or spaces in Text in Forum Post. BB Code for extra space ?

  1. #1
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Hi,
    . When trying to clearly explain something when answering a Thread, there are many occasions when having the ability to add extra spaces can be very useful. As we all know an annoying characteristic of most vBulletin Software is that it reduces all spaces greater than 1 back to 1
    . It must be possible to do, but I have often had a few Google sessions and have not hit in it yet.
    . There are loads of Links explaining how to do it in HTML code, but as yet I have found no BB Code to do it
    . I simply want to be able to add a given number of spaces between words or formulas when replying in a Forum Post.
    .
    . This my best solution up until now, anyone got any better or alternative suggestions?


    " big empty space " or ____________


    Thanks
    Alan



    ..................................
    P.s. The thing a bit in context....

    .”………. A characteristic of the VBA Evaluate Method, ( or rather The building of its String Argument ), which can be helpful in particular when trying to understand the tricky Theme of the different type of quotes in a long complicated string Argument, is that the pair of effectively empty VBA Evaluate quote pairs used in conjunction with an ampersand to link The Spreadsheet “world” to the VBA Code World can have any amount of spaces between them with no effect on the code line.
    .
    These basic Code lines
    Let ws.Range("B2").Value = Evaluate("=" & ws.Range("A1").Address & "") 'Explicit Version
    Let ws.Range("B2").Value = Evaluate("" & ws.Range("A1").Address & "") 'Implicit Default

    . May be rewritten
    Let ws.Range("B2").Value = Evaluate(" big empty space " & ws.Range("A1").Address & " big empty space ") '

    . As long as there is something in the total string to that can be evaluated this will not error. The explanation would be that within the VBA Evaluate “ “ pair nothing is being evaluated. It is a dead space. ( Note in parsing that it is common practice to leave out the “” & and & “” pair,
    .
    Let ws.Range("B2").Value = Evaluate(ws.Range("A1").Address)'Common but dangerous variation
    .
    . This can however catch you out as at least one “” & is good practice so as to ensure that a string is taken should the thing ____ inside the “” & _____ & ”” happen to be a number
    . - http://www.excelforum.com/excel-prog...ml#post4183530


    …………….”
    .
    . There will be situations where this can help later to identify which quotes are which, or to which “world” they belong…….”


    Demonstration in Code Window

    Please Login or Register  to view this content.
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    The same issue in formulas can be remedied with use of REPT() function where you can specify how many spaces you want there to be. Ex. =REPT(" ",5)
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Usually you add the entity code for space:
    HTML Code: 
    which will be changed to a space when posted.

    Ciao,
    Holger

    P.S.: I remember this to be a problem from when I first encountered vBulletin software in 2003, and the solution offered has been the very same ever since.
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Quote Originally Posted by AlKey View Post
    The same issue in formulas can be remedied with use of REPT() function where you can specify how many spaces you want there to be. Ex. =REPT(" ",5)
    Thanks for that, I may be able to use that elsewhere.

    My issue here was simply getting spaces to come out between text in a Forum Post. As you know the editor always reduces spaces to one when you post.

    .Thanks anyway for the reply

    Alan.

    P.s Did you get on OK in the end with the ADD - IN - did you get my PM about the File I had with the codes in as an alternative to an ADD-In if you were still having problems there?

  5. #5
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    @ HaHoBe
    . Danke ich habe, wie gesagt, das HTML Losung schon oft gesehen und ZB,. In MrExcel schon viel bemützt habe:
    . es hilft aber nicht bei Excel Forum da HTML ist OFF
    . Danke trotzdem

    . Thanks, as I mentioned I have seen that HTML solution having found it often bei „Googling“. Indeed I use it lots at Mr Excel.
    . However here it is no use as HTML is OFF
    . Thanks anyway

    Alan
    Gruß aus Bayern

  6. #6
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Quote Originally Posted by Doc.AElstein View Post
    P.s Did you get on OK in the end with the ADD - IN - did you get my PM about the File I had with the codes in as an alternative to an ADD-In if you were still having problems there?
    I guess there were too many links I tried to find the one I was looking for but failed. Thanks anyway.

    Alex

  7. #7
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Quote Originally Posted by AlKey View Post
    I guess there were too many links I tried to find the one I was looking for but failed. Thanks anyway.

    Alex
    OK sorry I could not help. ( I did send you a further PM with just that link in to the one I used in the Thread you noted, and a Further PM offering you a File with the code in for one of the tools rather than as an Add-In. )

  8. #8
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    I just use a line of tilde's and color them white
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  9. #9
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Hi xladept
    Quote Originally Posted by xladept View Post
    I just use a line of tilde's and color them white
    .. Thanks. I really should have thought of that .. i have been caught out when text in Excel cells are white which appears then to make the cell empty......
    .
    . I see it does not quite make the test “invisible “ in A Forum Thread
    http://www.excelforum.com/developmen...ml#post4191199
    http://www.excelfox.com/forum/f17/sa...1905/#post9500

    ... it is just about seeable by me ( You too ?? )
    .
    . But it is very close. ( Maybe A vbBulitin Board has a default background color slightly off- white – If I could find out what that color was then by putting the text to that color it would be invisible completely as in an excel spreadsheet cell ? )
    .
    . But for demonstration in a Thread it is certainly very close. Thanks
    ( Hopefully if someone then did copy a code line where I used this technique then they would realise and see the line of tilde's and delete them ( Of cours in a code tag it is no problem ........

    Please Login or Register  to view this content.
    .... ) )

    Thanks again xladept
    Alan

    P.s. ( I think might use something other than tilde's – I seem to remember they are sometimes used in a code for something. Maybe I will just write space ! )

  10. #10
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Hi Doc,

    Any old thing will do

  11. #11
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    I just use underscore characters in white font:

    Many spaces __________________ here.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  12. #12
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,725

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Doc, can I ask that you post normal text when you post. Your style of using different fonts and colors often make your posts unnecesarily hard to read
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  13. #13
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    @ Tony
    Quote Originally Posted by Tony Valko View Post
    .... underscore characters in white font:
    Many spaces __________________ here.
    ** yep the White font bit seems to be the one most people are using, and the underscore seem OK, - ‘bin just using that quite a bit, seems good.
    Thanks
    Alan

    **
    I’ll mark the Thread as solved in a Day or two if no other suggestions come in..
    *************

    @ FDibbins
    Quote Originally Posted by FDibbins View Post
    ..can I ask that you post normal text when you post. Your style of using different fonts and colors often make your posts unnecessarily hard to read
    * yep I do fight a bit with trying to get a clear final Thread. It is difficult with Editor Limitations and it does not always come out so good as I wanted. I confess when coming back to some of my Older Threads the long posts overwhelm myself.
    * I was slightly surprised by your comment to just use normal text..( or order – I respect your judgement and position here very highly so i will do what you say ). I have had a lot of good comments from Ops for my nice explicit “Pretty” explanations. ( You even gave me a Rep for one particularly “Pretty one”
    http://www.excelforum.com/excel-gene...ml#post4165851
    * But I’ll do me “blog” type posts elsewhere.
    *
    Thanks
    Alan..
    Last edited by Doc.AElstein; 09-17-2015 at 11:44 AM. Reason: Trying to stop Kyles Constipation

  14. #14
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,725

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Alan, I meant no offence by my suggestion, and the contents of your posts are good - even the paragraphing. It is just the colors you sometimes use

  15. #15
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    And could you possibly refrain from the full stops at the beginning of each line? - I find it difficult to parse

  16. #16
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Hi
    Just out of passing interest for anyone wanting to do anything similar to the subject of this Thread...
    http://www.excelforum.com/the-water-...tra-space.html

    _ I have a couple of codes now to do this. ( At least for the case that you are preparing your Post in Word**** before copying across to the Forum Editor. )
    _ ( The codes put in Orrin’s (xladept’s ) white Tidlie bits )

    _ The first basically does what you do manually when you use the “Find Replace Dialogue Box thing “..
    _ But note: Very important It effectively does a replace with a literal text string that is entered into the Replace dialog in Word, and that dialog uses your local system settings. So you may need to change this

    .Text = "~{1;}" 'German XL
    to
    .Text = "~{1,}" ' English XL !!!! *********

    Here is this code, ( to be used with XL Word )
    Sub AlanHansClipboardTextGetFindReplace()
    http://www.excelforum.com/showthread...t=#post4329034

    The above code will take for example this ( if it is selected in Word )
    Please Login or Register  to view this content.
    And then in the Clipboard you get this

    [color=white]~~~~~~~~~~~~~~~~[/color]I do not want the Forum Editor to [color=white]~~~~~~~~~~~~~~~~~~~~~[/color]EAT[color=white]~~~[/color]MY[color=white]~~~~~~~~~[/color].......S[color=white]~~[/color]P[color=white]~~~[/color]A[color=white]~~~~~[/color]C[color=white]~~~[/color]E[color=white]~~~~[/color]S[color=white]~~~~~[/color]!!!!!

    Which looks like that in the Forum Editor , ......but.......

    _............................ then... in the post itself it should look like this

    ~~~~~~~~~~~~~~~~I do not want the Forum Editor to ~~~~~~~~~~~~~~~~~~~~~EAT~~~MY~~~~~~~~~.......S~~P~~~A~~~~~C~~~E~~~~S~~~~~!!!!!

    _............................................................................................

    _ I did a second code , as a learning excessive and as a comparison. The second code uses ( I think ) all “VBA” things, in particular the Regular expressions stuff. There is then, for example no discrepancy with the
    _ "~{1,}"
    _ as VBA does things in “English” wherever you are!

    _ I did the code as an academic size. It makes an interesting comparison and as with the other code it has extensive explain ‘comments on it. It is currently limited to about 31 spaces, and i sometimes had some problems with a carriage return vanishing.

    Here is that code in two parts : ( Again to be used with XL Word )
    Sub REGinaldsExpressingWTFToReplace()

    http://www.excelforum.com/showthread...t=#post4329045
    http://www.excelforum.com/showthread...t=#post4329049
    Note: Both Parts are one code. The second part should be posted directly under the first part in the same Code module


    Thank you for watching!
    Reginbald Expressions
    ( aka Alan )
    ( aka DocAElstein (Banned) )

    P.s.
    BTW.,**** I have always done this Word Way, as I post a bit “rambling”. But considering recent problems with postings not working for one reason or another, or the original vanishing when editing, then others may wish to consider this option )


    Rem Ref
    http://www.eileenslounge.com/viewtopic.php?f=26&t=22603

  17. #17
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Hi Doc,

    Thanks for this.

    Orrin

  18. #18
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Quote Originally Posted by xladept View Post
    ......Thanks for this.
    Orrin
    Congratulations on your 8000 Tiddlie Wonk

    May you Tiddle Healthily further

    Orrins8000Tiddles.JPG

  19. #19
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Thanks Doc,

    I didn't realize what you were referring to - and thanks for the rep!

    How did you discover my Tilde trick? Did I tell you?

  20. #20
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Quote Originally Posted by xladept View Post
    ......
    How did you discover my Tilde trick? Did I tell you?
    yep... in this very Thread!!!!! ( The Thread we are in now!! )
    http://www.excelforum.com/the-water-...ml#post4190827

  21. #21
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Duhhhhhhhhh! You better get out of that Valley

    BTW - it should be Throe, just saying
    Last edited by xladept; 03-02-2016 at 01:56 PM.

  22. #22
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra space or spaces in Text in Forum Post. BB Code for extra space ?

    Thanks

+ 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] Unwanted extra space
    By makinmomb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-28-2014, 12:53 PM
  2. Remove extra space from the end of the cell contain text
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-31-2013, 09:55 AM
  3. Excel 2007 : Remove Extra Space
    By Jerseynjphillypa in forum Excel General
    Replies: 2
    Last Post: 11-08-2011, 12:09 PM
  4. Replies: 2
    Last Post: 03-11-2008, 11:26 AM
  5. [SOLVED] delete extra space
    By WBTKbeezy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-20-2006, 02:10 PM
  6. [SOLVED] Extra Line Space
    By Leesa in forum Excel General
    Replies: 1
    Last Post: 05-24-2005, 05:06 PM
  7. Extra line space
    By JJ in forum Excel General
    Replies: 1
    Last Post: 02-18-2005, 08:06 PM

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