Thread: find/replace "cr" from end of number to "-" in front of number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default find/replace "cr" from end of number to "-" in front of number
Try:

=LEFT(A1,LEN(A1)-2)*-1

HTH

"Dave o" wrote:

i have a spreadsheet with lots of numbers downloaded from our AS$)) system.
unfortunately, the columns have valid numbers and numbers like "******.**CR"
(* = a valid number).

i cannot get excel to convert the "CR" at the end of the number to a minus
sign in the front of the number.


any ideas?
Reply With QuoteReply With Quote