replacing values when text has *** in it

bill151515

Board Regular
Joined
May 19, 2005
Messages
87
I am trying to do edit replace for cells that have values like :: 12345***s

when I try and do the edit replace to get rid of the ***S portion with balnk the whole thing is replaced with a blank because of the *** is there a way around it so i can replace so it ends up with just whatever comes before the ***S portion (the end result could vary from anywhere between 5 and 10 char)
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
Use the squiggle on the top left of your keyboard to indicate a literal asterisk or question mark, otherwise Excel considers them wildcards.<ul>[*]~*[*]~?[/list]
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
Or do you mean you need<ul>[*]=left(A1,Len(A1)-4)) ?[/list] In which case use a temporary helper column with that formula, then paste values over the top and the cut and paste over the top of your original values.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,144
Messages
5,576,336
Members
412,718
Latest member
dragosm
Top