# Reverse Order while removing certain text

1. ## Reverse Order while removing certain text

Hi everyone! First post

The below example in column 2 is what I'm looking to pull from column 1. I've been able to get the following to work on the "Sandra White" example, but not the other two. I'd like it so the names are extracted from column 1, and put into column 2. My current formula works on all examples, but I would like to strip out the "VIP" text, as currently any VIP names on the list are becoming "John VIP Smith", which isn't what I'm looking for. Unfortunately this much more selective stripping is a little beyond my skill as everything I've tried to do with my current approach gives me an error. Any help is greatly appreciated!

 Smith, John VIP John Smith Jackson, Miss VIP Miss Jackson White, Sandra Sandra White

2. ## Re: Reverse Order while removing certain text

Data Range
 A B 1 Smith, John VIP John Smith 2 Jackson, Miss VIP Miss Jackson 3 White, Sandra Sandra White

Data Range
 B 1 =IFERROR(TRIM(SUBSTITUTE(TRIM(MID(A1,FIND(",",A1)+1,255))&" "&LEFT(A1,FIND(",",A1)-1)," VIP"," ")),"")

3. ## Re: Reverse Order while removing certain text

``Please Login or Register  to view this content.``

4. ## Re: Reverse Order while removing certain text

Originally Posted by :) Sixthsense :)
Data Range
 A B 1 Smith, John VIP John Smith 2 Jackson, Miss VIP Miss Jackson 3 White, Sandra Sandra White

Data Range
 B 1 =IFERROR(TRIM(SUBSTITUTE(TRIM(MID(A1,FIND(",",A1)+1,255))&" "&LEFT(A1,FIND(",",A1)-1)," VIP"," ")),"")
Thanks so much!
Quick question, is the 255 just to cover the standard character length limit?

5. ## Re: Reverse Order while removing certain text

Originally Posted by bloodlvst
Quick question, is the 255 just to cover the standard character length limit?
Yes, exactly. You can increase it based on your requirement.

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

#### 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