+ Reply to Thread
Results 1 to 10 of 10

Combine Text with Numbers with no spacing

  1. #1
    Registered User
    Join Date
    05-10-2019
    Location
    Penang, Malaysia
    MS-Off Ver
    2016
    Posts
    99

    Combine Text with Numbers with no spacing

    Hi All,
    this probably simple, but im stuck here.

    What i want to do is just to combine eg, A 12345 to A12345, (eliminate spacing to & from single cell).

    Thank-You very much

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    39,641

    Re: Combine Text with Numbers with no spacing

    Select the column and use Find & Replace to replace spaces with nothing.

    Otherwise, if no helper column is allowed, it will have to be VBA.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    05-10-2019
    Location
    Penang, Malaysia
    MS-Off Ver
    2016
    Posts
    99

    Re: Combine Text with Numbers with no spacing

    Hi AliGW,
    That was fast , actually i am aware for the replace, perhaps to rephrase my question, is there a formula for doing this?

    Thank-You very much

  4. #4
    Registered User
    Join Date
    05-10-2019
    Location
    Penang, Malaysia
    MS-Off Ver
    2016
    Posts
    99

    Re: Combine Text with Numbers with no spacing

    Hi again, AliGW,

    I see... I will just use the replace instead.
    will mark Solved for this thread.

    Thank-You very much

  5. #5
    Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    320

    Re: Combine Text with Numbers with no spacing

    Hi there,
    Assuming your cell with the' a 124' is in C#, a formula to remove spaces: =SUBSTITUTE(C3," ","") = 'a123'

  6. #6
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    2,021

    Re: Combine Text with Numbers with no spacing

    you can use a formula but the result will be in another cell

    =SUBSTITUTE(A1," ","")

  7. #7
    Registered User
    Join Date
    05-10-2019
    Location
    Penang, Malaysia
    MS-Off Ver
    2016
    Posts
    99

    Re: Combine Text with Numbers with no spacing

    Hi, ORoos, davsth

    Yes! thats what i was looking for... without knowing this can be done from a formula.
    Will add reputation to you both.

    Thank-You very much

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    39,641

    Re: Combine Text with Numbers with no spacing

    But you said this:

    eliminate spacing to & from single cell
    So I assumed you didn't want a formula in an adjacent column. Perhaps try to be a bit clearer next time.

  9. #9
    Registered User
    Join Date
    05-10-2019
    Location
    Penang, Malaysia
    MS-Off Ver
    2016
    Posts
    99

    Re: Combine Text with Numbers with no spacing

    Hi AliGW,

    My mistake, i have rephrase my question to the next comment. Ill be more precise next time..,
    I am thanking you too for the attention.

    Thank-You very much

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    39,641

    Re: Combine Text with Numbers with no spacing

    No worries.

+ 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. Currency Spacing between numbers above 100?
    By Carlx12 in forum Excel General
    Replies: 4
    Last Post: 02-14-2019, 05:43 AM
  2. Replies: 2
    Last Post: 08-03-2017, 10:21 AM
  3. [SOLVED] Combine Text with numbers driven from a formula, and include a comma
    By Perk1961 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-23-2015, 10:54 AM
  4. Macro for adding text, spacing, and a replace in a text string.
    By scapegoat9595 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2013, 10:44 AM
  5. Combine multiple cells in columns - Concat with variable spacing using VBA Script
    By AMC_CO in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-13-2013, 03:57 PM
  6. Arranging cells alphabetically with numbers and spacing
    By LastShadow in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-06-2010, 11:03 PM
  7. Adding Numbers beween spacing
    By Side.Order in forum Excel General
    Replies: 2
    Last Post: 10-25-2009, 04:21 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