Link to home
Start Free TrialLog in
Avatar of IT SSM
IT SSMFlag for Australia

asked on

Copy String to individual columns in new worksheet

Hi I want an excel Spreadsheet to look a text file and do some formatting based on a string of text

14:42:47 : B19 1 Rod drawn/pushed successfully on Bar Tensioner
14:45:47 : B19 1 Rod drawn/pushed successfully on Bar Tensioner
14:47:47 : B19 1 Rod drawn/pushed successfully on Bar Tensioner
14:52:47 : B19 1 Rod drawn/pushed successfully on Bar Tensioner

This data is located in a worksheet called Target Period
This is how the string represents in the Column B Cells 1 to 1000

I would like to look down the column and where the value B19 appears perform the following

I want to copy the string to individual columns in a new sheet called Data

I would like to put (14:42:47 into A1) (: into B1) (B19 into C1) and (1 into D1) and the rest of the string into E1

There might be up to 10 lines of other values in the data between the B19 values however would like the to copy into the new Data sheet on incremental rows. i.e. first instance row 1 second instance row 2
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.