Tex Split

Status
Not open for further replies.
C

ChetanPuri

Board Regular
Joined
Sep 5, 2018
Messages
80
Office Version
  1. 365
Platform
  1. Windows
Good Morning Excel Gurus,

I have a question for the range below to split the Codes for example at P2 R2402 into a seperate column, then 104 into another one and PR to another One and any (/) should be excluded if its the GL code which are just the numbers 40719240, they should stay the same.. Any help would be appreciated

V4 Telstra Download 2024-11-21.xlsm
P
1GL Code
2R2402/104/PR
3D100/130/MT
4D100/130/MT
5D100/160/MT
6D100/160/MT
7D100/140/MT
8C241/0800/PR
9C241/0800/PR
10C242/0800/PR
11C241/0800/PR
12C241/0800/PR
13C241/0800/PR
14C241/0800/PR
1540719240
1610119240
1711229392
1810119240
1940719240
2040739710
21DN04B/0800/PR
22NC01/52/PR
2350868416
2411229392
2540939240
2650868416
2750868416
2850908416
2911229392
3021609240
3140719240
3240119240
3310119240
3440119240
3540119240
3610119240
3740119240
38DM25/0100/MT
3910119240
4010119240
4121609240
42DM25/0100/MT
4310119240
4440719240
45DM25/0100/MT
4621609240
47DN03D/0800/PR
48DN20/5001/OH
4910559710
5040939710
5140719710
5240719710
5350909710
5450869710
5550869710
5650909710
5750909710
5850869710
5950869710
6050909710
6150909710
6211229390
6350869710
6450909710
6540739710
66M231/1040/PR
67D212/1075/PR
68D212/1075/PR
69D212/1075/PR
70D212/1075/PR
71C241/0700/PR
72C241/0700/PR
73D212/1075/PR
7410119720
7510119720
76D212/1075/PR
7710119720
7810119720
79C241/0700/PR
8021609720
8121609720
82C241/0700/PR
83C242/0700/PR
8421609720
85C242/0700/PR
86C241/0700/PR
87C241/0700/PR
8860559720
89D212/1075/PR
9011229391
9160559720
92D212/1075/PR
93C241/0700/PR
9450909720
9550909720
9650909720
9750909720
9860559720
9950869720
10050869720
10150869720
10250909720
10310559720
10410559720
10510559720
10621609720
107C242/0700/PR
108C241/0700/PR
10950869720
11060559720
11150919720
11210119720
113DN03D/0700/PR
11450869720
11510119720
11640119720
117C242/0700/PR
11810119720
119C241/0700/PR
120C242/0700/PR
121DN04B/0700/PR
12260559720
123D212/1075/PR
12411229391
125D212/1075/PR
126D212/1075/PR
127DN04B/0700/PR
128D212/1075/PR
129C242/0700/PR
130C241/0700/PR
13111229391
13250909720
13350869720
13450869720
13550909720
13611229391
137D212/1075/PR
138D212/1075/PR
139D212/1075/PR
140D212/1075/PR
141C241/0700/PR
142D212/1075/PR
14350909720
144D212/1075/PR
145C241/0700/PR
146D212/1075/PR
147D212/1075/PR
148C241/0700/PR
149D212/1075/PR
15050869720
15150919720
152C242/0700/PR
153C241/0700/PR
15411229391
155D212/1075/PR
156D212/1075/PR
15740119720
15840709720
15940709720
160C241/0700/PR
161NC01/52/PR
162D212/1075/PR
163D212/1075/PR
16440119720
165D212/1075/PR
166D212/1075/PR
167D212/1075/PR
168C241/0700/PR
169C241/0700/PR
170D212/1075/PR
171D212/1075/PR
17250909720
17350869720
174C241/0700/PR
175C242/0700/PR
176D212/1075/PR
17710559720
17840739710
17950909710
18050869710
18140739710
18240719241
18340719241
18440719241
18540719242
18640719242
18740719242
18840719242
18940719242
19040719242
19140719242
19240719242
19340719242
19440719242
19540719242
Detail Report
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Sort by date Sort by votes
Thank you Cubist, I just realised what I want is that if its just numbers I want it appear on a seperate column such as in S2 and if it is in this format
R2402/104/PR
then it splits in T2, U2 and V2 leaving S2 blank , as 2 should have values
 
Upvote 0
In future please do not post the same question more than once. Thread closed.
 
Upvote 0
Status
Not open for further replies.

Similar threads

S
  • Solved
Formula to split date and time and work out energy usage trend
Replies
6
Views
464
Sundance_Kid
S
S
  • Question Question
Code to use multiple trigger cells to hide / unhide rows of corresponding question sets
Replies
1
Views
1K
dmt32
D
J
  • Question Question
Help getting the data from other file
Replies
0
Views
285
janu319
J
D
  • Question Question
Data in cell wrong way round ie "15.22=1|13.33=3" should be "1=15.22|3=13.33" - must finish with data in 1 cell
Replies
3
Views
469
Fluff
Fluff
K
  • Question Question
Help with looping through an entire lists in Power Query
Replies
2
Views
520
JGordon11
JGordon11

Forum statistics

Threads
1,223,996
Messages
6,175,864
Members
452,678
Latest member
will_simmo

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