+ Reply to Thread
Results 1 to 4 of 4

Formulas: Number chararacters

  1. 04-20-2017, 01:38 AM #1
    ALLANT
    ALLANT is offline
    Registered User
    Join Date
    04-13-2016
    Location
    Laguna Philippines
    MS-Off Ver
    O365 PRO PLUS
    Posts
    68

    Formulas: Number chararacters

    Please help me out to provide the correct formula on how to get the desired characters in multiple cells.
    See attached file to figure it out.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-20-2017, 01:42 AM #2
    ImranBhatti
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Formulas: Number chararacters

    If the number of characters remain the same in your original data then this will work

    =RIGHT(A2,2)&" "&MID(B2,5,1)&" "&C2&" "&D2
    Teach me Excel VBA
    Reply With QuoteRegister To Reply
  3. 04-20-2017, 01:46 AM #3
    ALLANT
    ALLANT is offline
    Registered User
    Join Date
    04-13-2016
    Location
    Laguna Philippines
    MS-Off Ver
    O365 PRO PLUS
    Posts
    68

    Talking Re: Formulas: Number chararacters

    Perfect! Thank you very much!
    Reply With QuoteRegister To Reply
  4. 04-20-2017, 01:55 AM #4
    kev_
    kev_ is offline
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Formulas: Number chararacters

    or if the first space in the cells determine what you want
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count number of formulas used
    By Jake_fielder in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-03-2013, 02:55 AM
  2. Combining a number of IF formulas
    By ste1605 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-19-2013, 12:06 PM
  3. VBA to remove formulas from specific number columns (number changes each week)
    By DKerr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2013, 06:41 AM
  4. Row number in the formula should be increased by a constant number when a set of formulas
    By jpachika in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2012, 09:08 AM
  5. Phone number formulas
    By jakeiu in forum Excel General
    Replies: 1
    Last Post: 09-20-2009, 12:25 PM
  6. worksheet shows dates as number and formulas as formulas
    By baneVader in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-27-2008, 01:36 PM
  7. Letters and Number formulas
    By 2pojeff in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-24-2006, 07:15 PM
  8. [SOLVED] formulas and cells:using a number of different formulas for a number of cells
    By Aamir in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1