Stripping numbers from a cell

B

Bennets04

Board Regular
Joined
Jul 30, 2010
Messages
65
Hi All,
What would be the best formula to use to get the data from the below.... Im looking at just grabbing data in the [ ]'s from over 5,000 lines of data

Roshani [ RL52486 ] I'm looking to just get RLr2486
Ozlem [ OK51419 ] I'm looking to get OK51419
Robert [ RConville ] I'm looking to get RConville

Many thanks
Steve
 
Sort by date Sort by votes

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
You must log in or register to reply here.

Similar threads

J
  • Question Question
Pulling Data From ~300 Individual Sheets Onto a Master Sheet
Replies
1
Views
488
ranman256
ranman256
Q
  • Question Question
Macro needed to insert 4 rows in table, copy data from above, copy data from another sheet and paste special (transpose values) to those new rows...re
Replies
1
Views
489
sijpie
sijpie
A
  • Solved
Automate data export from multiple word tables into excel
Replies
8
Views
407
NdNoviceHlp
NdNoviceHlp
O
  • Question Question
Extracting data from one sheet to the next
Replies
3
Views
244
Rijnsent
Rijnsent
R
  • Solved
Character count on each line within one cell
3 4 5
Replies
40
Views
1K
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,226,117
Messages
6,189,061
Members
453,524
Latest member
AshJames

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