Dear All,
I want to retrieve first name except exclamatory sign [!],here CELL A1 is my input data & from these I prefer to get below output in the CELL B1
CELL A1(Input)
!DBE04 : ZGSDRI1B01
!MBE10 : JGSDRM1B33
!ABE40 : HGSDRK1B43
!ZBE55 : AGSDRE1B53
CELL B1 (Output)
DBE04
MBE10
ABE40
ZBE55
Bookmarks