I have data in Col A. I need a formula to extract the data in Col A where the Alpha just before the first numeric must contain a space for eg BR1PEB128 to look like this BR1PE B128
See attached sample data
Your assistance is most appreciated
I have data in Col A. I need a formula to extract the data in Col A where the Alpha just before the first numeric must contain a space for eg BR1PEB128 to look like this BR1PE B128
See attached sample data
Your assistance is most appreciated
Last edited by Howardc1001; 05-21-2019 at 11:07 AM.
What is the logic?
Maybe change this in your original codePlease Login or Register to view this content.
Thanks Fluff
Hi Pepe
The first Alpha before the number is the cell address
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks