Results 1 to 6 of 6

Adding In Forward Slashes After text (/)

Threaded View

  1. #1
    Registered User
    Join Date
    01-19-2012
    Location
    Manchester, United Kingdom
    MS-Off Ver
    Excel 2003 (WORK), Excel 2010 (Home)
    Posts
    24

    Adding In Forward Slashes After text (/)

    Hi All,

    Im currently working on something and im in need of some help in getting excel to populate a /1 after defiend text, however this should change in each cell such as.


    exmple:

    (D1)88987

    (A4)=IF(D1="","",D1) which inserts 88987 unless blank, however i need this to go as 88987/1
    then
    (A5)=IF(D1="","",D1) 88987/2

    And so forth

    I have tired custom format in which i can get it go to 00000/0 which shows 00000/1 however doesnt change the /1 in the next cell and so on.

    Does anyone know a way of getting the / to populate and to change the end numeber in each cell.

    Thanks in advance

    AV1D
    Last edited by AV1D; 01-19-2012 at 07:59 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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