+ Reply to Thread
Results 1 to 3 of 3

Add additional characters to already populated cell based on data entered in another cell

  1. #1
    Registered User
    Join Date
    04-17-2019
    Location
    Alberta, Canada
    MS-Off Ver
    Office 365
    Posts
    11

    Post Add additional characters to already populated cell based on data entered in another cell

    I am attempting to figure out a formula to add additional text characters to an already populated cell.
    Let me explain,
    I am looking to generate a "Reference number" or "code number" based on what i have entered into another field,
    all of my "reference numbers" begin with the same beginning characters (REF#1000-)
    The final 3 or 4 numbers of the reference are based on the price i enter into another field,
    if my price is $5.75 my "reference number" must end with 575, so my reference number in this instance would be REF#1000-575
    Is there a way i can input a formula so that the 575 is added to the REF#1000- once i input the price into the appropriate cell?
    I dont want to have to manually type out each reference number as there are multiple prices i will be inputting into the PRICE field.

    I hope this is clear, this is my first post on excelforum.com

    Thank you for your assistance.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,615

    Re: Add additional characters to already populated cell based on data entered in another c

    1. Delete REF#1000 from the entire column C.
    2. Column C formula: = B2 * 100
    3. Custom format C2:Cn - "REF#1000-"#
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    04-17-2019
    Location
    Alberta, Canada
    MS-Off Ver
    Office 365
    Posts
    11

    Talking Re: Add additional characters to already populated cell based on data entered in another c

    Thank you, this is exactly what I needed.

+ 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. Replies: 3
    Last Post: 08-09-2017, 10:40 AM
  2. Replies: 5
    Last Post: 09-28-2016, 07:02 PM
  3. [SOLVED] Formula to Add Additional Characters to an existing cell
    By Tamarissa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-05-2015, 07:00 PM
  4. Replies: 5
    Last Post: 02-19-2015, 11:10 AM
  5. [SOLVED] once cell E1 is entered need input box for date to be populated in B1
    By mlski4751 in forum Excel General
    Replies: 4
    Last Post: 07-23-2014, 04:20 PM
  6. [SOLVED] Based on two cells data validation list should be populated in third cell with unique vals
    By anchuri_chaitanya in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-13-2014, 03:21 PM
  7. [SOLVED] Formula Needed to copy data from a cell based on data entered into another cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-10-2013, 03:16 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