Results 1 to 7 of 7

duplicate last 4 characters of a cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    duplicate last 4 characters of a cell

    I would like to reproduce the contents of a cell but only the last 4 characters.
    Raw Data is in column A, and contains text and numbers but I'd like to sort the data using the last 4 characters in the cell.
    Each cell in Column A has varying amounts of text and numbers, so any formula needs to look right in cell contents, and only result the last 4 characters of that cell.


    So, I'd like to look at Cell A3, then reproduce the last 4 characters in Cell A7.

    Is this possible?
    Last edited by Christopherdj; 12-21-2011 at 05:48 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