+ Reply to Thread
Results 1 to 2 of 2

PROPER function for dynamic data entry?

  1. #1
    Registered User
    Join Date
    08-05-2006
    Posts
    63

    PROPER function for dynamic data entry?

    Fellow Forum Members,
    How do I apply the PROPER function to an entire column while the PROPER formula itself resides in a single cell? In this case my formula looks like this, "=PROPER(A:A)" in cell C1. My goal is for Column A to automatically format the data I input in this format:

    Column A1
    Thomas
    Smith
    Baker

    However, this is what I get:

    Column A1
    thomas
    smith
    baker


    What modification do I need to make to "=PROPER(A:A)" so that Column A dynamically modifies the data with an UPPERCASE letter for the first letter of a word as I type it in? My goal is not to create a second column of data that applies the PROPER formula by filling it down and referencing to a first column. I can't have duplicate columns of data. Any help will be greatly appreciated. Thanks in advance.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,974

    Re: PROPER function for dynamic data entry?

    How do I apply the PROPER function to an entire column while the PROPER formula itself resides in a single cell?
    short answer - you cannot.

    formulas ONLY affect the cell they reside in, they are not able to effect any other cells.
    Apart from VBA, the only way around this, would be to have =PROPER(A1) in a helper cell, then copy it down for all entries. If needed, you could copy/paste values from the formulas to the cells in column A, then delete the helper
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Dynamic Data Entry
    By hxman in forum Excel General
    Replies: 0
    Last Post: 04-19-2012, 10:24 AM
  2. [SOLVED] Auto Proper Case on Entry
    By John in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  3. Auto Proper Case on Entry
    By John in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. Auto Proper Case on Entry
    By Paul B in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 06:05 AM
  5. Auto Proper Case on Entry
    By John in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. [SOLVED] Auto Proper Case on Entry
    By John in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. [SOLVED] Auto Proper Case on Entry
    By John in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  8. [SOLVED] Auto Proper Case on Entry
    By John in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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