Excel_Split data of a Cell into two

[mimitan]

I have a a Price Column that has data as this:
Reg Price
---------
2/5.00
2/1.00
3/10.00
10/1.00
I can not do any calculation using this column. As a result I want to see if there is a way for me to split the data into 2 column as this
Reg Price Unit Price
--------- ---- -----
2/5.00 2 5.00
2/1.00 2 1.00
3/10.00 3 10.00
10/1.00 10 1.00
Thanks

 

[gizmo1973]

Copy the column 1st then on the new column
Text to columns with / as the de limiter
Data - Text to columns and follow the prompts!
It will only work each time you do this so if you add more you'll either need to populate 3 fields or run Text to columns again and again

Regards, Phil.

M.U.F.C. Show your true support here:

http://shareholdersunited.org/join.php?ref=125059000

"Shares not Shirts

 

[SkipVought]

Hi,

Select the data. Use menu item Edit/Text to columns - Delimited - and enter the [SLASH] as your delimiter.

Skip,
[sub]
[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?" [/sub]

 

[mimitan]

Thanks Phil & Skip!
That what I needed to do