+ Reply to Thread
Results 1 to 8 of 8

Manually typed codes conversion

  1. 11-11-2015, 06:01 AM #1
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Manually typed codes conversion

    Data on A

    Sample results required are on C and D done manually
    Reply With QuoteRegister To Reply
  2. 11-11-2015, 06:04 AM #2
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Manually typed codes conversion

    File attached is this
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 11-11-2015, 06:05 AM #3
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Manually typed codes conversion



    ..and the question is...?

    With examples please
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  4. 11-11-2015, 06:09 AM #4
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Manually typed codes conversion

    The data is on column A

    Attached sample output is on C and D
    Reply With QuoteRegister To Reply
  5. 11-11-2015, 06:11 AM #5
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Manually typed codes conversion

    C and D I have typed , I want macro to do that for me
    Reply With QuoteRegister To Reply
  6. 11-11-2015, 11:00 AM #6
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Manually typed codes conversion

    If there 50 lines , typing them takes long
    Reply With QuoteRegister To Reply
  7. 11-11-2015, 11:52 AM #7
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,531

    Re: Manually typed codes conversion 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 11-11-2015, 12:47 PM #8
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Manually typed codes conversion

    Thank you Jindon , wow I don't have to do the lengthy typing
    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. How to split dialing codes into country code and area codes
    By stefansfs in forum Excel General
    Replies: 7
    Last Post: 08-13-2015, 10:58 AM
  2. [SOLVED] Userform Combobox which filters list & also remembers manually typed in info?
    By Bflare in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 06-12-2014, 12:20 PM
  3. [SOLVED] Can you have auto updating AND manually typed permanent text in one cell?
    By elliottt in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 03-06-2014, 03:12 PM
  4. How to use the countif funtion to count a codes that contain cells with muliple codes.
    By BillyBarr96 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-10-2013, 12:28 AM
  5. Need VBA Statement(s) Help: Find Codes within String to Replace with New Codes Concatenate
    By dtuck in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2013, 07:59 PM
  6. Specify range of cells including spaces, manually typed text and line breaks in VBA
    By LindaABH in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2012, 12:59 AM
  7. How to auto populate 2 cells on different sheets if manually typed into on either sheet.
    By wegobryan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2012, 02:24 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