Tags: TEXT TO COLUMNS

Convert multiple columns of numbers into text at once

{ 4 Comments }

Assume numbers in range C10:C13 as 12,23,34,45.  Assume numbers in range E10:E13 as 56,67,78,89.  For uploading these two columns (along with other columns as well) into an ERP, C10:C13 and E10:E13 need to be converted to text values i.e. numbers stored as text values. Once way to do this is to: 1. Select C10:C13 and to go Data […]

Read More →

Split multiple lines of data in one cell to multiple columns

{ 0 Comments }

To split multiple lines of data appearing in one cell (originally entered via Alt+Enter) into multiple columns, try this 1. Select the data range and go to Data > Text to columns > Delimited > Next 2. Ensure that all delimiters are unchecked 3. Check the box for Other and in the type Ctrl+J > […]

Read More →