Hi All
Need help to remove text within a cell
Mac123ab KFC321 BK999ab Longjohn22ab PizzaH45
The data which I require to remove is "ab" which may/may not be present.
The "ab" would always be at the end of the data.
Hi All
Need help to remove text within a cell
Mac123ab KFC321 BK999ab Longjohn22ab PizzaH45
The data which I require to remove is "ab" which may/may not be present.
The "ab" would always be at the end of the data.
Either do a global replace or use SUBSTITUTE in a helper cell.
=SUBSTITUTE(A1,"ab","")
or a VBA routine to remove the text in the cell (also using SUBSTITUTE)
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks