filtering?
here are are a few columns from my worksheet. I would like to extract the word "capacity" from the column and take the number only from the parenthesis and add it to another column. This is done for hundreds of columns and they change daily so this would be very helpful.
Thanks! any help would be great
CLR0895_NORII_11: Capacity: 499.75 GB (102.57 GB free)
CLR0895_NORII_12_T1: Capacity: 499.75 GB (232.85 GB free)
CLR0895_NORII_13: Capacity: 499.75 GB (41.35 GB free)
CLR0895_NORII_14: Capacity: 499.75 GB (165.77 GB free)
CLR0895_NORII_15: Capacity: 499.75 GB (70.53 GB free)
CLR0895_NORII_16: Capacity: 499.75 GB (56.08 GB free)
CLR0895_NORII_17: Capacity: 499.75 GB (152.29 GB free)
CLR0895_NORII_18_T1: Capacity: 499.75 GB (71.32 GB free)
Because columns don't show properly in posts, try uploading a sample workbook or tell us specifically what is in column A, B, C, etc. and what you would like the result to look like.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks