Hi There
Please see attached for a small sample of my problem file.
Most cells have 3 lines of data and I want to get all three lines into an adjoining cell in a continuous one-line format.
Secondarily, I need to break up the address into a mail-merge format, so the continuous address shows over 5 cells or so (address1, Address2, City, State, Postcode)
I have seen some advice elsewhere which describes how to do a regular text to columns instruction but instead type '010' in the 'other' Delimiter box.
Also, some advice about 'find & replace' function to replace the 'carriage returns' with a symbol and then use the symbol as a delimiter.
If you try 'text to columns' in either of these scenarios on the ATTACHED data, when it gets to step 2 of the Wizard, only a fraction of the data shows, i.e. the first line.
Can anyone help explain how to get the data in each cell in column A to be spread out over many cells on the same row, using Text to |Columns?
Thanks
Mick
Please see attached for a small sample of my problem file.
Most cells have 3 lines of data and I want to get all three lines into an adjoining cell in a continuous one-line format.
Secondarily, I need to break up the address into a mail-merge format, so the continuous address shows over 5 cells or so (address1, Address2, City, State, Postcode)
I have seen some advice elsewhere which describes how to do a regular text to columns instruction but instead type '010' in the 'other' Delimiter box.
Also, some advice about 'find & replace' function to replace the 'carriage returns' with a symbol and then use the symbol as a delimiter.
If you try 'text to columns' in either of these scenarios on the ATTACHED data, when it gets to step 2 of the Wizard, only a fraction of the data shows, i.e. the first line.
Can anyone help explain how to get the data in each cell in column A to be spread out over many cells on the same row, using Text to |Columns?
Thanks
Mick