How to get values separated with /
 

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

How to get values separated with /
 

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" wrote in message
...

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

How to get values separated with /
 

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

How to get values separated with /
 

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" wrote in message
...

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

How to get values separated with /
 

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.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=520592

How to get values separated with /
 

DataText to ColumnsDe-limited by / character.


Gord Dibben MS Excel MVP

On Thu, 9 Mar 2006 09:46:02 -0600, Oleg
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