Removing Text Duplicates in a Cell without Delimiters

R

rnelz

New Member
Joined
Sep 4, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hi All,

I'm looking to remove the duplicate text in a column of cells the are not separated by delimiters. For example, a cell will contain the text "FashionFashion", while another cell will contain "Home & GardenHome & Garden". My goal is to separate these cells to only contain "Fashion" and "Home & Garden", respectively. I've attached a screenshot of the actual data I'm working with for reference.

I've been looking for any formula or VBA solutions, but have come up short. Any help/suggestions would be much appreciated.

Best,

Ryan
 

Attachments

  • Capture.PNG
    Capture.PNG
    15.8 KB · Views: 16

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Sort by date Sort by votes
Hi & welcome to MrExcel.
How about
=LEFT(A2,LEN(A2)/2)
 
Upvote 0
Wow! Such an elegant solution. Thank you so much Fluff!
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Excel 2021 - Sum cells that contain text for total and total by month
Replies
1
Views
97
bebo021999
B
L
  • Question
Trouble splitting text to columns
Replies
6
Views
435
Peter_SSs
Peter_SSs
N
  • Locked
  • Question
Compare data in columns, remove duplicates and return unique values in a new column
2
Replies
12
Views
489
Peter_SSs
Peter_SSs
O
  • Question
Separating Text
Replies
4
Views
158
NdNoviceHlp
NdNoviceHlp
R
  • Solved
Using conditional formatting to highlight the row of a cell containing specific text.
Replies
4
Views
388
etaf
etaf

Forum statistics

Threads
1,215,622
Messages
6,125,889
Members
449,270
Latest member
bergy32204

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top