|
Text to Column
Is there any way to separate Dollar amount to another column (last five
digits)? Not all figuers have a $ sign in front of the amount. Thank you USPS 0545019576 LOS ANGELES CA 9.60 USPS 0545019576 LOS ANGELES CA 9.40 USPS 0545019577 LOS ANGELES CA 4.70 SHELL OIL 57442712808 UPLAND CA 16.20 VONS FUEL 10026813 UPLAND CA 26.50 |
Text to Column
If you want the last 5 characters, use =RIGHT(A1,5) if you want it as text,
or =RIGHT(A1,5) if you want it as a number. -- David Biddulph "ajyourpal" wrote in message ... Is there any way to separate Dollar amount to another column (last five digits)? Not all figuers have a $ sign in front of the amount. Thank you USPS 0545019576 LOS ANGELES CA 9.60 USPS 0545019576 LOS ANGELES CA 9.40 USPS 0545019577 LOS ANGELES CA 4.70 SHELL OIL 57442712808 UPLAND CA 16.20 VONS FUEL 10026813 UPLAND CA 26.50 |
Text to Column
=RIGHT(A1,5)
"ajyourpal" wrote: Is there any way to separate Dollar amount to another column (last five digits)? Not all figuers have a $ sign in front of the amount. Thank you USPS 0545019576 LOS ANGELES CA 9.60 USPS 0545019576 LOS ANGELES CA 9.40 USPS 0545019577 LOS ANGELES CA 4.70 SHELL OIL 57442712808 UPLAND CA 16.20 VONS FUEL 10026813 UPLAND CA 26.50 |
Text to Column
Thank you. Worked like a charm.
"Mike" wrote: =RIGHT(A1,5) "ajyourpal" wrote: Is there any way to separate Dollar amount to another column (last five digits)? Not all figuers have a $ sign in front of the amount. Thank you USPS 0545019576 LOS ANGELES CA 9.60 USPS 0545019576 LOS ANGELES CA 9.40 USPS 0545019577 LOS ANGELES CA 4.70 SHELL OIL 57442712808 UPLAND CA 16.20 VONS FUEL 10026813 UPLAND CA 26.50 |
Text to Column
David meant:
=--right(a1,5) if you want it as a number. The -- is the same thing as multiplying by -1 twice. But it also changes the text value (returned from the =right() function) to a real number. David Biddulph wrote: If you want the last 5 characters, use =RIGHT(A1,5) if you want it as text, or =RIGHT(A1,5) if you want it as a number. -- David Biddulph "ajyourpal" wrote in message ... Is there any way to separate Dollar amount to another column (last five digits)? Not all figuers have a $ sign in front of the amount. Thank you USPS 0545019576 LOS ANGELES CA 9.60 USPS 0545019576 LOS ANGELES CA 9.40 USPS 0545019577 LOS ANGELES CA 4.70 SHELL OIL 57442712808 UPLAND CA 16.20 VONS FUEL 10026813 UPLAND CA 26.50 -- Dave Peterson |
Text to Column
Yes, of course I did. Thanks, Dave. It's a good job one of us was awake.
-- David Biddulph "Dave Peterson" wrote in message ... David meant: =--right(a1,5) if you want it as a number. The -- is the same thing as multiplying by -1 twice. But it also changes the text value (returned from the =right() function) to a real number. David Biddulph wrote: If you want the last 5 characters, use =RIGHT(A1,5) if you want it as text, or =RIGHT(A1,5) if you want it as a number. -- David Biddulph "ajyourpal" wrote in message ... Is there any way to separate Dollar amount to another column (last five digits)? Not all figuers have a $ sign in front of the amount. Thank you USPS 0545019576 LOS ANGELES CA 9.60 USPS 0545019576 LOS ANGELES CA 9.40 USPS 0545019577 LOS ANGELES CA 4.70 SHELL OIL 57442712808 UPLAND CA 16.20 VONS FUEL 10026813 UPLAND CA 26.50 -- Dave Peterson |
Text to Column
Thank you
At first I could not change the format to $ because I coverted it to text. Now I will change it again with the new formula as a number. "David Biddulph" wrote: Yes, of course I did. Thanks, Dave. It's a good job one of us was awake. -- David Biddulph "Dave Peterson" wrote in message ... David meant: =--right(a1,5) if you want it as a number. The -- is the same thing as multiplying by -1 twice. But it also changes the text value (returned from the =right() function) to a real number. David Biddulph wrote: If you want the last 5 characters, use =RIGHT(A1,5) if you want it as text, or =RIGHT(A1,5) if you want it as a number. -- David Biddulph "ajyourpal" wrote in message ... Is there any way to separate Dollar amount to another column (last five digits)? Not all figuers have a $ sign in front of the amount. Thank you USPS 0545019576 LOS ANGELES CA 9.60 USPS 0545019576 LOS ANGELES CA 9.40 USPS 0545019577 LOS ANGELES CA 4.70 SHELL OIL 57442712808 UPLAND CA 16.20 VONS FUEL 10026813 UPLAND CA 26.50 -- Dave Peterson . |
| All times are GMT +1. The time now is 04:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com