Deleting part of a cell

jaybeen

New Member
Joined
Apr 4, 2002
Messages
1
Hello,

I want to delete part of a cell in Excel. For example if a cell had the data "BlueGreen" how would I delete the "Blue" bit just to leave the "Green" bit behind? Surely there is an easier way then physically deleting the first part in each cell??? I have about 4000 cells to work on!!
Please help and regards,
Jaybeen.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Hiya,

Use the following formula to strip out everything after the ...

=RIGHT(A1,LEN(A1)-SEARCH("",A1))

And if you just wanted to pick up the first part try...

=LEFT(A1,LEN(A1)-SEARCH("",A1)-1)

Rgds
AJ
This message was edited by AJ on 2002-04-05 02:59
 
Upvote 0
I want to separate this -
3200x13998
or
2453x9900

into 2 cells; ie.
[3200] [13998]
[2453] [9900]

I used the formulas....

=LEFT(JE,LEN(JE)-SEARCH("X",JE)-1)
=RIGHT(J3,LEN(J3)-SEARCH("X",J3))

this produced -
[3200] [13998]
[245] [9900]

Is there another formula for the left side that will work in either case ?

Thanx,
REABTBN
 
Upvote 0
Dave,

Thanks - I tried Data / Test to Columns -
Checked Treat consecutive delimiters as one

no apparent effect.

Regards,
REABTBN
 
Upvote 0
Dave,

Thanks - I tried Data / Test to Columns -
Checked Treat consecutive delimiters as one

no apparent effect.

Regards,
REABTBN
 
Upvote 0
On 2002-04-05 02:30, jaybeen wrote:
Hello,

I want to delete part of a cell in Excel. For example if a cell had the data "BlueGreen" how would I delete the "Blue" bit just to leave the "Green" bit behind? Surely there is an easier way then physically deleting the first part in each cell??? I have about 4000 cells to work on!!
Please help and regards,
Jaybeen.

At Step 2 of 3 of the Text to Columns wizard...

1. Check the "Other" box and enter "" into its field.
2. Also, check the "Treat consecutive delimiters as one" check box.

At Step 3 of 3 select the first parsed column, assign "Do not import column (Skip)" attribute, and press [ Finish ].
This message was edited by Mark W. on 2002-04-08 15:41
 
Upvote 0
select the column and go to the Edit menu, and select "Replace". You want to replace "Blue//" with nothing.

This works.
 
Upvote 0
If your data is always in that format "Blue\Green", but the text changes (Red\Orange), and you always want just the second part, do a search and replace with a wild card, as in replace *\ with nothing.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,207
Members
448,554
Latest member
Gleisner2

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