This will also work. The TRIM will remove any unneeded spaces.
Formula:
=TRIM(SUBSTITUTE(A1,"(GB)",""))
This will also work. The TRIM will remove any unneeded spaces.
Formula:
=TRIM(SUBSTITUTE(A1,"(GB)",""))
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks