Splitting data on | lines

[Kvv]

Is there a formula that can split into individual cells this data?

H|19-080724B|20240807|
D|08291|30|20240806|320264
D|08291|34|20240806|320247
D|72900|1|20240805|320253
D|72900|1|20240805|320255
D|72900|1|20240805|320254
D|72900|1|20240805|320256
D|72900|1|20240805|320257
D|72900|1|20240805|320258
X|0070540185|20240806|49.100
X|0070540215|20240806|49.100
X|0070540206|20240806|49.100
X|0070540218|20240806|49.100

I am using =mid but when number of characters changes I have to adjust each row.

 

[Sektor]

If you have Excel 2021+ or Excel 365:

=TEXTSPLIT("D|72900|1|20240805|320254","|")

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Kvv]

If you have Excel 2021+ or Excel 365:

If you have Excel 2021+ or Excel 365:

=TEXTSPLIT("D|72900|1|20240805|320254","|")

365

Thank you works great...

 

[Sektor]

You're welcome!