This script creates a custom hotkey for instant L-R formatting propagation, useful in high-speed data entry environments.
To pull a first name out of a full name string, you need to tell Excel to find the space character dynamically. =LEFT(A2, FIND(" ", A2) - 1)
The formatting from the left column is now replicated across all selected cells to the right. Importantly, this method preserves the destination values and formulas.
Before diving into the methods, let’s consider the practical benefits:
The content (and formatting/formulas) from the left cell is instantly copied into the selected range on the right.
To copy all text to the left of a specific delimiter (like a space, comma, or hyphen): =LEFT(A2, FIND(" ", A2) - 1)
Cell D4 has $1,234.00 with red negatives. Copy that format to E4, F4, G4 without changing their values. Paste Special > Formats.
Tip: Double-click the icon to lock it on, allowing you to paint multiple separate rows. Method B: Paste Special (Best for Large Datasets) Copy your source cell ( Ctrl + C ).
Enter this formula vertically to pull data automatically from the horizontal layout. 5. Advanced L/R Automation with Power Query
English 
