Further Help

S

Simon

Thanks for the help but I forgot to add in something.

this formula '=left(A1,2)&right(A1,2)' pulled back 'AC58'
in cell 'B2' from 'AC1003258' from cell 'A1'.

I now need to have the middle numbers in cell 'C1'. so
the answer would be '10032'.

Can anyone help???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Special string convertion to date and time 5
If, Or, and 5
text to date..! 4
Time Calculations Help 5
Referencing the values of multiple cells in conditinal formatting. 0
Help with an if then scenario 2
Help with IF Function for times. 5

Top