Ian Bell
asked on
Remove symbols and commas from values
Hi,
I'd like an Excel formula to remove symbols and commas
examples
£5,620 to 5600
€47,800 to 47800
The only currencies are £ and €
Many thanks
Ian
I'd like an Excel formula to remove symbols and commas
examples
£5,620 to 5600
€47,800 to 47800
The only currencies are £ and €
Many thanks
Ian
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I tested what I posted and it works. Did it not work for you?
ASKER
I found the answer
=IF(A14="","",PROPER(SUBST ITUTE(SUBS TITUTE(LEF T(F14,IFER ROR(FIND(" (",F14)-1, LEN(F14))) ,"`","")," '","")))
=IF(A14="","",PROPER(SUBST
So you must be converting text not numbers . I would not have known that from your post
ASKER
No John, didn't work at my end.
ASKER
Oh yes John, please forgive me. The formula cell had a currency format when changed to number it worked.
You are right. I have used that formula for many years but forgot about the format
You are right. I have used that formula for many years but forgot about the format
Thanks for the update. I was happy to help you recollect it.
ASKER
Thanks John a timely reminder. I'm going senile :)
No not at all :) We all forget stuff.
ASKER