Use a formula to separate numbers from text

I need help with a formula to separate my numbers from text in a cell. I have seen the following and can get it to work if a cell has BA123 in it:
Use following functions to separate your text and numbers from a cell.

To separate text - "=LEFT(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789"))-1)"
To separate number - "=RIGHT(A2,LEN(A2)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789"))+1)"

My data is backwards: example
Given Data-----------------------Need formula to retrieve number--------------------Need formula to retrieve letters
79---------------------------------------------79
79A-------------------------------------------79----------------------------------------------------A
234------------------------------------------234
234A----------------------------------------234----------------------------------------------------A
234B----------------------------------------234----------------------------------------------------B

I tried substituting A,B,C etc for the numbers above, but the formula is not understood

Thank you,
Sharon

Hi Tony, Thank you for your response. At this point it is a single letter, but I am not sure what they will do in the future, so I was looking for a solution that might eventually accommodate the need to add AA, etc. to the end.

I added the dashes, just to separate the columns. The data is not complex. I am just provided with a code that is a number with no letter, or a number with one letter. For now, let's assume that those are the only 2 cases. If they begin to add multiple letters at the end of the code, I will deal with it at that time.

The code provided is currently a text string. The result generated in column B must be numeric, the result generated in Column C is text.
The same formula must be used in column B for all rows.
The same formula must be used in column C for all rows.

Here are some examples not much different from my post but may be clearer.

Provided code in A1 is 69
Need a formula in B1 to generate 69
Need a formula in C1 to generate nothing

Provided code in A2 is 69A
Need a formula in B2 to generate 69
Need a formula in C2 to generate A

Provided code in A3 is 235
Need a formula in B3 to generate 235
Need a formula in C3 to generate nothing

Provided code in A4 is 235B
Need a formula in B4 to generate 235
Need a formula in C4 to generate B

This is basically it ... the codes provided are simple.

Please let me know if you need any further information to help. Thank you so much.
Sharon

Tony,
This is great. I have 2 questions. I have been looking around, but have not been able to determine what - in front of RIGHT and -- in front of LEFT mean. Can you please help me understand the meaning of the dashes (negative signs)?

I checked the result of column B with an ISNUMBER and although it came back true, it did not do a numeric sort. I had to add VALUE to the formula. Can you let me know if I did this properly as I, again, am not sure of the impact of the dashes:
=IF(COUNT(-RIGHT(A6)),VALUE(A6),VALUE(--LEFT(A6,LEN(A6)-1)))

Thank you so much for your help. I really appreciate it.
Sharon

Tony,
Thank you ... can you tell me what the "^" and the - and the "--" in your formulas please?
I am in bed now, but I will try your last formula in the morninr.
Thank you so very much. i will get back to you.
Take care,
Sharon

I'm sorry ... thank you, Alkey - yours was the first post i saw in another forum. Can you help me understand your first formula? My questions are with 10^308 and the "--" before LEFT. Does this formula need to be entered as an array?
Thank you for your response.
Sharon

Thank you all so much for your solutions and for your explanations. I understand it now. I was able to use Tony's solution in a SharePoint List which works very well and Alkey's solution in an Excel spreadsheet as either SharePoint doesn't support some of the formulaic content or I made an error entering(:; I will try again soon. Alkey's solution also works perfectly in Excel.

I so appreciate all of your timely and clear responses; they will all be used in my project.

Thank you again and I will mark this as SOLVED.
Sharon