I am having difficulties how to TRIM a cell by removing all leading characters up until the letter "B" is encounterd. NOTE: The number of characters before the letter "B" can vary in lenght. Can someone assist?
Example
BEFORE:
RESULT NEEDED:
Example
BEFORE:
04/28/2021 08:02 AM 4,071,367 BJC form_SENT_04_28_2021.xlsx |
BJC form_SENT_04_28_2021.xlsx |