How to get values separated with /

[Oleg]

For example,
I have a values separated with / in A1 cell
58555/55665
In result I want to get a value before / in A2(58555) cell and value
after / in A3 cell (55665)

 

[Guest]

Hi

In the case you have posted you can use:
=LEFT(A1,5)
in A2 and
=RIGHT(A1,5)
in A3.
If it's more complicated than that, post back.

Hope this helps.
Andy.

 

[Oleg]

But I have different count of digits before and after / in each row

for example:

A
1 55/56899
2 5888/545
3 248/54477

 

[Guest]

Hi
You'll have to use this method then:
=LEFT(A1,FIND("/",A1)-1)
in A2 and
=MID(A1,FIND("/",A1)+1,LEN(A1)-FIND("/",A1)+1)
in A3.

Andy.

 

[wjohnson]

Select your column - then go to Menu Bar - and Select Data - Text to
Columns and follow the instructions - this will put your data in
Columns A and B - then just copy column B and paste below column A. If
the numbers need to be in a particular order Copy your Column A - Open
WORD and Paste.
Then select the column - then on the MENU Bar - Select TABLE - CONVERT
- TABLE to TEXT.
Then in the Find and Replace Box - In the FIND enter /
In the REPLACE - enter ^p - This will separate all of your number and
put them one below the other.
Then COPY and PASTE back into EXCEL and you will be done.

 

[Gord Dibben]

Data>Text to Columns>De-limited by / character.


Gord Dibben MS Excel MVP