Convert 18 digit ID to 15 digit ID in Excel

Question

Immediate Requirement plz give approaches I have Exported Account object records using DataLoader. ID's in the csv(Excel) file have (a0r90000008cJzaAAE) 18 digit.But i want those as (a0r90000008cJza)15 digit in the same sheet or other Excel Sheet. I write formula "=LEFT(A2,15)" , it was truncated but when i tried to copy those cell to other Excel sheet It's getting nothing like blank because it was a formula cell. What to do? Plz tell me approaches

Daniel Ramirez · Accepted Answer

Ummm... simply copy and paste special as values (not regular paste). You can override the current column or onto a new column.

Geoffrey Flynn · Answer

Copy - Paste Special - Values  the entire column to lock out the formula and turn it into text   http://www.extendoffice.com/documents/excel/763-excel-replace-formula-with-results-value.html   or   Use Text to Columns to cut the last 3 characters   https://support.office.com/en-us/article/Split-names-by-using-the-Convert-Text-to-Columns-Wizard-2cd989db-2b1f-4d89-b17b-534250ff9905?CorrelationId=f78a85f9-efb2-4b83-9296-530e4a269412&ui=en-US&rs=en-US&ad=US  ( https://support.office.com/en-us/article/Split-names-by-using-the-Convert-Text-to-Columns-Wizard-2cd989db-2b1f-4d89-b17b-534250ff9905?CorrelationId=f78a85f9-efb2-4b83-9296-530e4a269412&ui=en-US&rs=en-US&ad=US )

Convert 18 digit ID to 15 digit ID in Excel

Data Management

Aprendizaje relacionado

Más ayuda