+ Reply to Thread
Results 1 to 9 of 9

Stock card description renaming

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,642

    Stock card description renaming

    I have say the following

    ARIEL WALL 25 X 35 = SNOW WHITE WM290A

    result needed

    MML 25 X 35 = ARIEL SNOW WHITE WM290A

    Find attached file , do not want do this for 100 cards manually

    Notes :
    1 add word MML TO start
    2 remove word WALL or FLOOR
    2 Shift all words before size to after = sign
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,642

    Re: Stock card description renaming

    Maybe it will need formula helper added columns

    Don't mind that too provided the end result is auto

  3. #3
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Thumbs up Re: Stock card description renaming

    Hi Makin..
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Check the attached file...
    Attached Files Attached Files
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  4. #4
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,642

    Re: Stock card description renaming

    Vikas that was hot and cool

    Exactly what I needed

  5. #5
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,642

    Re: Stock card description renaming

    Vikas there is a small error

    Its picking all cards as ARIEL

    This one too

    NYETRA 30 X 60 = CORNSILK MATT MB340A

  6. #6
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,642

    Re: Stock card description renaming

    You will have to edit the formula to read First word instead of
    writing ARIEL into the formula , not all tiles type are ARIEL

  7. #7
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Thumbs up Re: Stock card description renaming

    Correction..
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Check the attached file...
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,642

    Re: Stock card description renaming

    Vikas Thanks again

    I know the thread is solved , asking added favor

    If this is in c1

    MML 25 X 35 = ARIEL SNOW WHITE WM290A

    And I want , SHIFTING LAST WORD AFTER FIRST WORD AFTER THE =

    MML 25 X 35 = ARIEL WM 290A SNOW WHITE

  9. #9
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Thumbs up Re: Stock card description renaming

    Done it..
    But this time with a UDF...
    Please Login or Register  to view this content.
    Check the attached file...
    Attached Files Attached Files

+ 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. need help to make stock card with data entry form
    By malikshakeel in forum Excel General
    Replies: 0
    Last Post: 04-09-2013, 03:56 PM
  2. [SOLVED] Credit card type based on card number
    By wlsnoops in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-26-2013, 10:25 AM
  3. Replies: 0
    Last Post: 10-28-2012, 07:22 AM
  4. Replies: 6
    Last Post: 07-01-2011, 09:38 AM
  5. create new simple stock card / control
    By SelinaT in forum Excel General
    Replies: 0
    Last Post: 09-22-2010, 11:34 PM

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