using alt+tab in one cell

A

akram

I have a spreadsheet with many rows. in one of the
column i have information like the one shown below:

07-10-02 05-08-02 2812114 $54.40 144078 Aug 2001 -
Jul 2002 !81110677;01-30-03 12-27-02 3208564
$408.00 150581 Aug 2002 - Jul 2003 !81110677;03-24-03
02-28-03 S3.217-144 -$306.00 152834

I have to make it like this:

07-10-02 05-08-02 2812114 $54.40 144078 Aug 2001 -
Jul 2002 !81110677;
01-30-03 12-27-02 3208564 $408.00 150581 Aug 2002 -
Jul 2003 !81110677;
03-24-03 02-28-03 S3.217-144 -$306.00 152834

is there any way i can replace ; to alt+tab.

Thank you,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Returning a Date with Multiple Criteria Lookup Values 0
Conditional Time Calculation 10
Date Function 2
Sum value between two dates and copy to new cell 7
When building a chart Dates are been included that are not in thedate range 2
Copy value according to date 1
Find then highlight in yellow 6

Top