+ Reply to Thread
Results 1 to 3 of 3

Custom Cell Formatting - "Label" Cells

  1. #1
    Registered User
    Join Date
    11-16-2019
    Location
    Seattle, USA
    MS-Off Ver
    2010
    Posts
    1

    Custom Cell Formatting - "Label" Cells

    Hey, I have an Excel table filled with text and I'd like to label my cells with their row and column (ie., "1A - texttexttext", "51G - moretextmore"). I tried going into Format Cells/Custom, but I'm not really sure how to create a new type. I thought...

    CELL; "-"; Text

    ...would work but it doesn't.

    Thanks in advance!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Custom Cell Formatting - "Label" Cells

    Hi and welcome
    you posted an Excel question in the "Outlook" forum .
    I will move it accordingly

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Custom Cell Formatting - "Label" Cells

    Custom number format will only format the contents of the cell. It will not provide any information about it's position on the grid.
    There for you would need to have static information in the number format about row/column and each cell would require it's own custom number format.

    Can you explain why you need row/column prefix in the cell, perhaps we can suggest an alternative approach that would not require hundreds or maybe thousands for number formats.
    Cheers
    Andy
    www.andypope.info

+ 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] Conditional Formatting - Apply Cell Style if a column cell is "string1" or "string2"
    By Tunnel_Snakes in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-29-2018, 01:27 PM
  2. Replies: 2
    Last Post: 07-13-2018, 11:52 PM
  3. Conditional Formatting Red or Green Cells and Sum the amount in a "total cell"
    By AdamTaylor3 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-03-2018, 07:15 AM
  4. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  5. Replies: 2
    Last Post: 09-12-2013, 10:56 PM
  6. [SOLVED] Data validation: allow entry into a cell if other three cells have "X", "Y" and "Z"?
    By RogerRangeRover in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2013, 04:49 AM
  7. [SOLVED] scatter plots and "label" as ("X" value1, value2)
    By shabnam in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-11-2005, 10:06 AM

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