Results 1 to 4 of 4

Printing DATA found in another column with text in front of it on a different column.

Threaded View

RDx Printing DATA found in... 06-17-2008, 05:29 PM
oldchippy Hi, Do you mean something... 06-17-2008, 05:44 PM
TIPPYS I think you want something... 06-17-2008, 05:44 PM
RDx Thats perfect guys, thanks! ... 06-17-2008, 08:57 PM
  1. #1
    Registered User
    Join Date
    12-04-2006
    Posts
    9

    Printing DATA found in another column with text in front of it on a different column.

    Hello I need some help with something extremely simple.

    I have 4 columns

    A B C D

    Column A has a number, lets say 5 now i need column D to print the data in column A with the word B in front of the number and DF after the number, B5DF


    Example

    A B C D
    5 B5DF
    6 B6DF
    7 B7DF

    I can't use cell formatting. I need a formula that will lookup the value on column A print it in column C and add the letters before and after the number.
    Last edited by oldchippy; 06-17-2008 at 05:45 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