How to get values separated with /

Posted to microsoft.public.excel.misc

Gord Dibben

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
hiding zero values in charts	fascal	Charts and Charting in Excel	4	December 19th 05 02:17 PM
Keeping a cell value constant trhoughout a list of values	borikua05	Excel Worksheet Functions	2	December 3rd 05 03:03 PM
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row	Sam via OfficeKB.com	Excel Worksheet Functions	6	November 29th 05 03:27 PM
I Need a formula to evaluate a cell with + or - values	Bob in Oklahoma	Excel Worksheet Functions	6	October 31st 05 02:41 PM
#N/A Values : Returned by Formulas vs Entered Manually	monir	Charts and Charting in Excel	8	July 7th 05 01:16 AM

All times are GMT +1. The time now is 10:23 AM.

Menu

About Us