=RIGHT(A2, LEN(A2) - FIND("-", A2)) This subtracts the hyphen position from the total text length to calculate exactly how many characters to extract from the right. Method 4: Power Query (The Enterprise Solution)
If you want to apply this to a specific project, let me know: What are you splitting? (Names, codes, dates?) Is the data always the same length , or does it change? Do you need to keep the original column , or delete it? l r copy format in excel
Note: There is no native single-key shortcut for Fill Left like there is for Right ( ) or Down ( 2. Copying Formatting Only =RIGHT(A2, LEN(A2) - FIND("-", A2)) This subtracts the
Using an explicit Excel Table locks the data structure and ensures that any formulas written on the Right side can dynamically reference the exact table columns. Step 3: Format the Right (R) Side Using Formulas Do you need to keep the original column , or delete it
For bespoke dashboards that cannot use Tables, VBA provides a programmatic L-R solution.