Reading from slashes [SOLVED]

Hi,

I want to be able to have certain cells automatically filled in from a one cell of data containing slashes dividing the different required data in the cells.

It looks looks like the following for example cell P1= A/B/C/D/E/F

I want cell A1 to show A and and cell B1 to show B, etc etc.

How would I able to figure out how to do this?

Thank you

In A1, copied across:

=TRIM(MID(SUBSTITUTE("/"&$P1,"/",REPT(" ",125)),125*COLUMNS($A:A),125))

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.