Forum Discussion
update Excel File Name (Rename an Excel Sheet), and it auto updates a specific cell in the workbook
I do have a question, that I seem to be hitting a wall on. Is it possible to update an Excel File Name (Rename an Excel Sheet), and it auto update a specific cell in the workbook? Here is the next ...
mtarler The MID works, but I am hitting a road block.
Here is my example of a book name:
21MJNXXX. Customer Name. Job Name. REV 1
I need to separate each section into a cell of there own...
21MJNXXX
Customer Name
Job Name
REV 1
The "Text to Columns" function will not work because it shows the formula. Not the actual text. I have tried =LEFT, =LEFT(RIGHT, .... =LEFT(MID... but I can't seem to get this right? Is it possible do the text to columns with code?
As variant
=LET(txt, A1, delim, ".", nDelim, LEN(txt)-LEN(SUBSTITUTE(txt, delim,"")),
ch, UNICHAR(9999),
n, SEQUENCE(1,nDelim+1),
nn, SEQUENCE(1,nDelim+1,2),
startPos,IFERROR(FIND(ch,SUBSTITUTE(txt,delim,ch,n-1))+1,1),
numChars, IFERROR(INDEX(startPos,nn)-1,LEN(txt)+1)-startPos,
TRIM(MID(txt,startPos,numChars))
)for
SergeiBaklan This worked as well. thank you both!