Results 1 to 3 of 3

Thread: Delete Specific Text from Column of Cells

  1. #1

    Delete Specific Text from Column of Cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Folks

    In the attached file you will see text like USD,RM,EA, etc. I need either a formula or a Macro to delete these texts from the Cells. Any ZZ+number should remain together with the number in the left. From time to time new text may be introduced to delete so I need a way to add them.

    I'd appreciate your feedback.

    Many thanks

    Brian
    Attached Files Attached Files

  2. #2
    Super Moderator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    754
    Articles
    0
    I have no idea what you want - sorry. Please add your desired outcome manually to the workbook and post again.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    741
    Articles
    0
    It would appear that your data is uniform in layout, but might you have a line with 2 characters to remove (e.g. RM), and also a ZZ+number to remain? (Your sample data does not have such an example).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •