Ask Your Question
1

How do I separate this information into each cell from copy/paste

asked 2021-02-13 02:58:29 +0200

JG101 gravatar image

updated 2021-02-13 03:00:48 +0200

Is there a trick to separate this information into there own cells from copy/paste or does it need to be done post paste. Please show with current information.

20210212|A|4692|7198|B

20210212|AA|5096|8696|B

20210212|AAAU|3688|5236|B

20210212|AAC=|0|1000|B

20210212|AACG|2325|3173|B

20210212|AACQ|1500|3778|B

20210212|AACQW|100|200|B

Thank you in advance for any help provided.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2021-02-14 10:18:53 +0200

Earnest Al gravatar image

updated 2021-02-14 10:21:11 +0200

You can do it on import but no standard options on Paste

Select the cells, click Data > Text to Columns, under Separator Options in the box labelled Other enter the pipe character |. The first column looks like a date, if it is then change the column type to Date (YMD). If some of the numbers are text labels, e.g. post codes, equipment numbers, then change the column type to Text, otherwise leve as Standard. Press OK. Cheers, Al

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-02-13 02:58:29 +0200

Seen: 27 times

Last updated: Feb 14