Deleting a space from the end of a value

[razor_raef]

Hi all,

I've created a button with macro assigned to paste a value from clipboard onto cell E4.

Sometimes users will have a space bar at the end of the value which causes an error for another cell calculating a value.

Is there a way in excel you can change the value of a cell from e.g "1234 " to "1234" automatically?

Thanks,
Raef

[elayaz]

Hi,

use trim(). If the value is in a1, then trim(a1) will remove the space.

-----------------------------------

If my reply helped, Please add reputation (click on the star below the post)
If the reply solves your problem, Don't forget to mark the thread as "Solved" (Thread Tools->Mark thread as Solved)

[krishnaiah]

hi friend,

U can use TRIM function otherwise which column u having spaces concatenate with one special charecter for next column next use find and replace function find the value " special character" (i.e space and special character) replace with blank

we can remove spaces at word ending

[razor_raef]

Worked a charm. Thanks.