Hi everyone,
I have a spreadsheet that contains a column of data that is a mixture of letters, numbers and symbols all based on the last row of the keyboard. The data looks like this:
23C\v
5B\n
12<\.
23Z?\zc
This data is used to create whole numbers and fractions when exported to another program. (The numbers represent the whole number and the case-sensitive letters and symbols represent the numerators and denominators.)
I need to be able to separate the numerical portion of the cells from the rest by adding a space between the numbers and everything else. (23Z?\zc will become 23 Z?\zc) The backslash will always be included, but there could be one or two numbers or symbols before and after the backslash. The characters before the backslash can include the following characters between the quote marks: "ZXCVBNM<>?" The characters after the backslash can include: "zxcvbnm,./"
Is there any formula that can be used to separate this data or will I have to record macros searching for the various combinations?
Any help is much appreciated!
I have a spreadsheet that contains a column of data that is a mixture of letters, numbers and symbols all based on the last row of the keyboard. The data looks like this:
23C\v
5B\n
12<\.
23Z?\zc
This data is used to create whole numbers and fractions when exported to another program. (The numbers represent the whole number and the case-sensitive letters and symbols represent the numerators and denominators.)
I need to be able to separate the numerical portion of the cells from the rest by adding a space between the numbers and everything else. (23Z?\zc will become 23 Z?\zc) The backslash will always be included, but there could be one or two numbers or symbols before and after the backslash. The characters before the backslash can include the following characters between the quote marks: "ZXCVBNM<>?" The characters after the backslash can include: "zxcvbnm,./"
Is there any formula that can be used to separate this data or will I have to record macros searching for the various combinations?
Any help is much appreciated!
Last edited: