+ Reply to Thread
Results 1 to 2 of 2

use 1 column data to replace another column but different format

  1. #1
    Registered User
    Join Date
    02-13-2018
    Location
    WALSALL, ENGLAND
    MS-Off Ver
    MICROSOFT OFFICE 2007
    Posts
    3

    Post use 1 column data to replace another column but different format

    excelhelp.JPG

    excelhelp.JPG

    newbie here,

    this is an imported sheet from another company, but to input it on to our system it needs a slight re-jig.

    Column "R" = words "PRIORITY" OR "STANDARD"

    if this is the case i need the column "AM" answers replacing with what ever is in column "R" BUT in a different format i need it with just capital letter at beginning.
    ie - "Standard" or "Priority"

    is there a way of doing this quickly instead of copy and pasting across?

    all help great fully received

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,937

    Re: use 1 column data to replace another column but different format

    You can use Proper function. Have a look at below link

    https://www.techonthenet.com/excel/formulas/proper.php
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

+ 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] Replace data in one column automatically based on another column
    By jzacharias in forum Excel General
    Replies: 1
    Last Post: 06-22-2015, 01:30 PM
  2. Replies: 3
    Last Post: 11-25-2014, 06:08 AM
  3. Macro need Arranging column data in Quiz format using transpose and Text to Column Feature
    By successramesh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2014, 02:58 AM
  4. Replies: 4
    Last Post: 12-16-2013, 06:29 PM
  5. Look for data in column A, if there replace if not there search column B, if not there...
    By jhamer-arthrex in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2013, 03:44 PM
  6. [SOLVED] Macros to find the dates in a column and replace with a different format. Excel 2003
    By Ashwin Sundarajan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-12-2012, 12:08 AM
  7. Replace data in a column
    By coasterdude in forum Excel General
    Replies: 1
    Last Post: 12-07-2005, 12:45 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