LinkBack URL
About LinkBacks
Hi,
I have this file which has leading spaces in column R of H1 sheet,I have used trim function and then converted it to number,but still it is not working,due to that the value in pivot is also showing '0'
Hi,
I have this file which has leading spaces in column R of H1 sheet,I have used trim function and then converted it to number,but still it is not working,due to that the value in pivot is also showing '0'
You need to take PO Line Balance Qty and not PO Line Amount Balance.
PO Line Amount Balance has space at the end and can be removed with SUBSTITUTE function.
Never use Merged Cells in Excel
Hi,
Sorry for the wrong communication I want to remove space from PO line amount balance column where in certain places there are 1 space and in some cells more than 1,can you you guide me as to how to use the substitute function .
Try =SUBSTITUTE(A1, " ", "")
Change A1 is your desired cell.
However, this will return you a text. (So 5 03 will become 503 (a text value).
If you expecting number use: =--SUBSTITUTE(A1, " ", "") but this will return you error for text values (so 5A03 will become #VALUE!)
Try this:
Confirmed with Crl-Shift-Enter
Please Login or Register to view this content.
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks