Remove "x" number of characters from left of cell

ChrisRitchie

New Member
Joined
Nov 15, 2011
Messages
47
Hi all

I would like to copy the 1st 3 letters from the left of a cell and then remove these 3 characters from that cell too.

I have used =LEFT(B3,3) to copy the characters but I don't know how to remove those 3 characters from the cell, B3.

I appreciate any guidance you could provide.

Kind regards
Chris
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Ahh, yes. Good thinking, thank you!

To complicate it further, column B has 300+ records all with a varying degree of the following text:
173 ISDN BT
162 TIE Virgin
2011 T1 BTW

I would like to separate all 3 bits of data into 3 columns. The only common thing about all cells is that the text is separated by a space in column B cells.

Thanks
Chris
 
Upvote 0
Hi all

I would like to copy the 1st 3 letters from the left of a cell and then remove these 3 characters from that cell too.

I have used =LEFT(B3,3) to copy the characters but I don't know how to remove those 3 characters from the cell, B3.

I appreciate any guidance you could provide.

Kind regards
Chris

I'm partial to MID function method myself. :)

=MID(A1,4,255)
 
Upvote 0
Thanks Mike

I am using Excel 2010 on Win7.

This is extremely handy, but to be even more complicated, some of the names in the column B are further separated by spaces.
eg:
173 ISDN BT
162 TIE Virgin
175 2MB BT Wholesale
762 ISDN A B C D

Can you still help, otherwise I will use a combination?

Thanks for your assistance!
Chris
 
Upvote 0
One other thing, can I reverse the the text to column ?
IE: after I have removed some data, can I reverse the action?
eg: 173 ISDN BT TEN Five = 173, ISDN, BT, TEN, Five, remove 173 and ISDN, and combine BT, TEN, Five back into a single cell?

Thanks again!
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,972
Members
448,537
Latest member
Et_Cetera

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