+ Reply to Thread
Results 1 to 2 of 2

Text in Cell to column translation

  1. #1
    Registered User
    Join Date
    08-03-2015
    Location
    Iceland
    MS-Off Ver
    0002
    Posts
    17

    Text in Cell to column translation

    I would like to know if someone could create a VBA to transfer the text in one column to the corresponding rows and columns in the other table.
    I would prefer if you could translate with text instead of with numbers. Maybe this involves Macros, I don't know. I want a letter translation, not digital numbers. ThanksText to Columns (3).xlsx

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Text in Cell to column translation

    see attached solution

    formulas are already preset
    then macro code for the text to column splitting based on space and Comma delimiter


    Please Login or Register  to view this content.
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Text functions -- translation tables and dupilcates
    By jerrykid9 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-01-2015, 09:59 PM
  2. [SOLVED] Compare text in a cell to text in a column on another sheet & return text from 3rd cell
    By marks@bcmr.com in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-06-2014, 05:33 AM
  3. Real time text translation to match the language selectedin language vailidation
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2013, 09:23 PM
  4. Replies: 6
    Last Post: 02-23-2012, 11:18 PM
  5. [SOLVED] column value translation
    By charles in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 06-15-2006, 04:20 PM
  6. & function cell format translation.
    By Waikato300zxClub@gmail.com in forum Excel General
    Replies: 4
    Last Post: 04-07-2006, 07:20 AM
  7. Translation of Column Headers?
    By bludovico in forum Excel General
    Replies: 1
    Last Post: 04-12-2005, 12:04 PM

Tags for this Thread

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