How can I remove part of a cell value?

English
#1

I have over 1500 rows of value to be changed.
The cell has a combination value of date and numbers. And my task is to change them into two columns. Column (A) is DATE and Column (B) is WOrder. My question is, is there an easy way to do this than to just copy and paste the values into the new column? Thanks ahead for any help or solution.

example: 1/10/20237131415189
12/9/202281953616919

sample file:
Large Numbers.ods (19.3 KB)

#2

Large Numbers_GS.ods (23,4,KB)

1 Like
#3

Thank you, it works perfectly.
Additional question: If I want to delete Column (A), how can I retain the new values of Column (B) & (C)?

Again, thank you. You made it so “easy”.

#4

Copy B and C and Paste as unformatted text over the top of them, then delete column A

#5

Thanks EarnestAl, that was a big help also, allowing me to sort by date, which I was trying to figure out how. Thanks again to both of you guy’s.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.