Hello,
I am not sure this is possible, but I am looking for a formula to show the string after 5 spaces from the left up to the space before a pattern. The pattern is a number that will always have a 2-digit decimal place and I would want to show prior to the space before it.
For example,
1357 09-013 1 10605 1234567890 1x16 WINDING BROOK-4.4 52.45 123456789 32 ____ = 1x16 WINDING BROOK-4.4
3504 02-024 1 10884 0000zxcas0 3/0 STRANDED THHN BLACK 4.65 320560 24 ____ = 3/0 STRANDED THHN BLACK
I was using the formula below which worked some of the time but the amount of spaces between words was not consistent.
=TRIM(MID(SUBSTITUTE(B21," ",REPT(" ",99)),6*99-98,99)) &" "& TRIM(MID(SUBSTITUTE(B21," ",REPT(" ",99)),7*99-98,99))&" "& TRIM(MID(SUBSTITUTE(B21," ",REPT(" ",99)),8*99-98,99))
Any help would be appreciated
I am not sure this is possible, but I am looking for a formula to show the string after 5 spaces from the left up to the space before a pattern. The pattern is a number that will always have a 2-digit decimal place and I would want to show prior to the space before it.
For example,
1357 09-013 1 10605 1234567890 1x16 WINDING BROOK-4.4 52.45 123456789 32 ____ = 1x16 WINDING BROOK-4.4
3504 02-024 1 10884 0000zxcas0 3/0 STRANDED THHN BLACK 4.65 320560 24 ____ = 3/0 STRANDED THHN BLACK
I was using the formula below which worked some of the time but the amount of spaces between words was not consistent.
=TRIM(MID(SUBSTITUTE(B21," ",REPT(" ",99)),6*99-98,99)) &" "& TRIM(MID(SUBSTITUTE(B21," ",REPT(" ",99)),7*99-98,99))&" "& TRIM(MID(SUBSTITUTE(B21," ",REPT(" ",99)),8*99-98,99))
Any help would be appreciated