Single Cell Text Data 1

[Topcat04]

Hi There

The system in the office is very old! Unfortunately when it produces reports it produces it as a text file in Excel, but ALL the data on a row is in a single Row (Row A)

It is able to manage the line breaks and place them in additional rows but there are approx 10 'columns' of data all in column A.

The data is unfortunately not uniformed in length...but a common factor is that the information that I require is always 5 'spaces' after the A. See a snippet below to help explain.

CXXX071070-61 PRODUCT DESCRIPTION A 5024.000 13.40

What is the best way of being able to cut this information up when the product Description is not a set length. Is there a way of being able to work with the spaces or use the data directly after the A.

Thanks for your help,

 

[SkipVought]

Hi,

Check out Data > Text to columns -- FIXED

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Topcat04]

Thanks Skip!