| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Needed - Truncate extra spaces at end of variable text len
Apollo Environmental Strategies
B&B Laboratories The cells pasted above have variable blank spaces at the end. I need spaces removed at the end of each cell using a formula. -- Thanks for the help in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Needed - Truncate extra spaces at end of variable text len
=TRIM(A1)
-- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Roibn Taylor" wrote: Apollo Environmental Strategies B&B Laboratories The cells pasted above have variable blank spaces at the end. I need spaces removed at the end of each cell using a formula. -- Thanks for the help in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| removing extra spaces | Excel Discussion (Misc queries) | |||
| how do I insert a variable amount of blank spaces in a formula? | Excel Worksheet Functions | |||
| Removing random extra spaces | Excel Discussion (Misc queries) | |||
| Extra Spaces with copied data | Excel Discussion (Misc queries) | |||
| Sum product help needed with an extra variable please and thankyou | Excel Worksheet Functions | |||
Linear Mode
