Hi,
I need to remove some character from a cell and keep some character.
For Example
Input
Cell A1 -> ABCD-EFGH-IJKLM
I need this Output in Cell B1
EFGH-IJKLM
Pls help with the formula. Thanks in advance.
Hi,
I need to remove some character from a cell and keep some character.
For Example
Input
Cell A1 -> ABCD-EFGH-IJKLM
I need this Output in Cell B1
EFGH-IJKLM
Pls help with the formula. Thanks in advance.
Is the format always like this? Are there always blocks of 4 characters separated by a hyphen?
If so
=RIGHT(A1,9)
Ed
_____________________________
Always learning, but never enough!
_____________________________
Hi,
Something like this
=RIGHT(A1,LEN(A1)-5)
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thanks Forum Guru & Moderator for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks