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)

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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)
>
>
> --
> Oleg
>
>
> ------------------------------------------------------------------------
> Oleg's Profile:
> http://www.excelforum.com/member.php...fo&userid=4004
> View this thread: http://www.excelforum.com/showthread...hreadid=520592
>

[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

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.

"Oleg" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
>
> --
> Oleg
>
>
> ------------------------------------------------------------------------
> Oleg's Profile:
> http://www.excelforum.com/member.php...fo&userid=4004
> View this thread: http://www.excelforum.com/showthread...hreadid=520592
>

[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

On Thu, 9 Mar 2006 09:46:02 -0600, Oleg
<[email protected]> wrote:

>
>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