SIMPLE data extraction form Column A to B

[mecutemecute]

color-numbersout-help.xlsx

I need information from Column A to show on Column B WITHOUT the numbers in the format as shown in the attachment. As you can see Even the character BEFORE the number in column A should not populate in column B (example ROWS 7-8) the "Ju" is also not showing.

Thanks in advance!

[martindwilson]

with your data this works

Please Login or Register  to view this content.

[mecutemecute]

EXCELLENT!! thanks again!