Results 1 to 87 of 87

Removing characters from different cells based on contents in a separate cell

Threaded View

Nightowel23 Removing characters from... 03-13-2021, 08:05 PM
Gregb11 Re: Removing characters from... 03-13-2021, 09:28 PM
Nightowel23 Re: Removing characters from... 03-14-2021, 04:28 AM
Glenn Kennedy Re: Removing characters from... 03-14-2021, 05:21 AM
Nightowel23 Re: Removing characters from... 03-14-2021, 05:54 AM
AliGW Re: Removing characters from... 03-14-2021, 05:24 AM
Glenn Kennedy Re: Removing characters from... 03-14-2021, 05:26 AM
AliGW Re: Removing characters from... 03-14-2021, 05:30 AM
AliGW Re: Removing characters from... 03-14-2021, 06:01 AM
Nightowel23 Re: Removing characters from... 03-14-2021, 06:06 AM
kvsrinivasamurthy Re: Removing characters from... 03-14-2021, 06:03 AM
AliGW Re: Removing characters from... 03-14-2021, 06:14 AM
kvsrinivasamurthy Re: Removing characters from... 03-14-2021, 06:20 AM
JohnTopley Re: Removing characters from... 03-14-2021, 06:36 AM
Nightowel23 Re: Removing characters from... 03-14-2021, 06:37 AM
JohnTopley Re: Removing characters from... 03-14-2021, 06:38 AM
Glenn Kennedy Re: Removing characters from... 03-14-2021, 06:40 AM
JohnTopley Re: Removing characters from... 03-14-2021, 06:49 AM
JohnTopley Re: Removing characters from... 03-14-2021, 06:55 AM
Nightowel23 Re: Removing characters from... 03-14-2021, 07:12 AM
JohnTopley Re: Removing characters from... 03-14-2021, 07:17 AM
Nightowel23 Re: Removing characters from... 03-14-2021, 07:33 AM
JohnTopley Re: Removing characters from... 03-14-2021, 08:00 AM
JohnTopley Re: Removing characters from... 03-14-2021, 08:24 AM
Nightowel23 Re: Removing characters from... 03-14-2021, 08:57 AM
JohnTopley Re: Removing characters from... 03-14-2021, 09:35 AM
kvsrinivasamurthy Re: Removing characters from... 03-14-2021, 10:14 AM
Nightowel23 Re: Removing characters from... 03-14-2021, 10:55 AM
Nightowel23 Re: Removing characters from... 03-14-2021, 11:11 AM
kvsrinivasamurthy Re: Removing characters from... 03-14-2021, 11:27 AM
Nightowel23 Re: Removing characters from... 03-14-2021, 11:41 AM
kvsrinivasamurthy Re: Removing characters from... 03-14-2021, 11:41 AM
Nightowel23 Re: Removing characters from... 03-14-2021, 11:43 AM
kvsrinivasamurthy Re: Removing characters from... 03-14-2021, 11:49 AM
Nightowel23 Re: Removing characters from... 03-14-2021, 12:15 PM
Nightowel23 Re: Removing characters from... 03-14-2021, 12:25 PM
kvsrinivasamurthy Re: Removing characters from... 03-14-2021, 12:49 PM
Nightowel23 Re: Removing characters from... 03-14-2021, 01:10 PM
JohnTopley Re: Removing characters from... 03-14-2021, 02:21 PM
Nightowel23 Re: Removing characters from... 03-14-2021, 04:07 PM
JohnTopley Re: Removing characters from... 03-14-2021, 04:31 PM
Glenn Kennedy Re: Removing characters from... 03-14-2021, 02:54 PM
Nightowel23 Re: Removing characters from... 03-14-2021, 04:27 PM
Nightowel23 Re: Removing characters from... 03-14-2021, 04:38 PM
JohnTopley Re: Removing characters from... 03-14-2021, 04:50 PM
JohnTopley Re: Removing characters from... 03-14-2021, 04:53 PM
Nightowel23 Re: Removing characters from... 03-14-2021, 06:25 PM
kvsrinivasamurthy Re: Removing characters from... 03-15-2021, 01:33 AM
JohnTopley Re: Removing characters from... 03-15-2021, 02:55 AM
Nightowel23 Re: Removing characters from... 03-16-2021, 04:41 AM
Nightowel23 Re: Removing characters from... 03-16-2021, 05:08 AM
kvsrinivasamurthy Re: Removing characters from... 03-16-2021, 06:35 AM
Nightowel23 I have added a surname row... 03-16-2021, 06:55 AM
JohnTopley Re: Removing characters from... 03-16-2021, 07:02 AM
kvsrinivasamurthy Re: Removing characters from... 03-16-2021, 07:09 AM
Nightowel23 Re: Removing characters from... 03-16-2021, 08:05 AM
JohnTopley Re: Removing characters from... 03-16-2021, 09:24 AM
Nightowel23 Re: Removing characters from... 03-16-2021, 09:56 AM
kvsrinivasamurthy Re: Removing characters from... 03-16-2021, 09:28 AM
Nightowel23 Re: Removing characters from... 03-16-2021, 10:03 AM
JohnTopley Re: Removing characters from... 03-16-2021, 12:41 PM
Nightowel23 Re: Removing characters from... 03-16-2021, 01:04 PM
JohnTopley Re: Removing characters from... 03-16-2021, 01:16 PM
Nightowel23 Re: Removing characters from... 03-16-2021, 01:30 PM
Nightowel23 Re: Removing characters from... 03-16-2021, 01:49 PM
JohnTopley Re: Removing characters from... 03-16-2021, 02:23 PM
Nightowel23 Re: Removing characters from... 03-16-2021, 02:31 PM
Nightowel23 Re: Removing characters from... 03-16-2021, 02:41 PM
JohnTopley Re: Removing characters from... 03-16-2021, 02:45 PM
Nightowel23 Re: Removing characters from... 03-16-2021, 02:47 PM
JohnTopley Re: Removing characters from... 03-16-2021, 02:51 PM
Nightowel23 Re: Removing characters from... 03-16-2021, 03:26 PM
JohnTopley Re: Removing characters from... 03-16-2021, 05:27 PM
Nightowel23 Re: Removing characters from... 03-16-2021, 02:51 PM
kvsrinivasamurthy Re: Removing characters from... 03-17-2021, 03:53 AM
Nightowel23 Re: Removing characters from... 03-17-2021, 06:50 PM
kvsrinivasamurthy Re: Removing characters from... 03-18-2021, 12:43 AM
jindon Re: Removing characters from... 03-18-2021, 09:22 AM
Nightowel23 Re: Removing characters from... 03-20-2021, 10:49 AM
kvsrinivasamurthy Re: Removing characters from... 03-20-2021, 12:58 PM
Nightowel23 Re: Removing characters from... 03-20-2021, 01:59 PM
kvsrinivasamurthy Re: Removing characters from... 03-21-2021, 09:15 AM
Nightowel23 Re: Removing characters from... 03-21-2021, 09:37 AM
kvsrinivasamurthy Re: Removing characters from... 03-22-2021, 12:24 AM
  1. #1
    Registered User
    Join Date
    02-23-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    49

    Removing characters from different cells based on contents in a separate cell

    Hello all, hope someone can help with this.

    How can I remove the characters (initials) "BD, NK, PS" that appear in the light blue cell at the bottom from where they are in the white cells above. The order in which they may appear in the light blue cell can be random and the initials can vary at different times but will always match initials somewhere in the white cells above. The positions of the initials in the white cells is always fixed.

    I have tried to nest a few search and replace functions but have had no luck.

    Any ideas? Thank you
    Attached Files Attached Files
    Last edited by Nightowel23; 03-13-2021 at 08:09 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adjust cell contents based on another cells contents
    By spyac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2018, 10:34 AM
  2. Help removing to the right of certain characters in cells
    By williamsp15 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2015, 06:32 PM
  3. [SOLVED] Distribute contents of a cell into other cells according to number of characters
    By Sacharny in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-14-2013, 10:38 AM
  4. Excel 2007 : Removing rows based on cell contents
    By jsnacker in forum Excel General
    Replies: 7
    Last Post: 12-20-2010, 05:09 PM
  5. Removing characters from multiple cells
    By sp1974 in forum Excel General
    Replies: 4
    Last Post: 05-21-2010, 04:16 PM
  6. How do I separate cell contents into 2 cells using a comma as the marker?
    By jfarlow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2008, 11:47 AM
  7. Replies: 1
    Last Post: 03-18-2008, 07:03 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