This content has been marked as final. Show 4 replies
1 of 1 people found this helpful
As a suggestion try
REPLACE([Vendor ID], '
Thanks Haitham, It worked!
u r welcome
instead of removing the new line you can limit your characters by using LEFT or MID function.