How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Pete Your Own Question

Pete
Pete, Computer Expert
Category: Microsoft Office
Satisfied Customers: 15758
Experience:  MS Office expert
30970729
Type Your Microsoft Office Question Here...
Pete is online now
A new question is answered every 9 seconds

158. I am having difficulty with mid function. I am getting

This answer was rated:

158. I am having difficulty with mid function.

I am getting Excel output file created in SAP.

I want to to strip characters from left and right of the contents of cells.

Mid function tells me that it is doing it bit I don't see the destination columns fill with the rigjt data.

Whats up with the mid functuon?

ITPeter :

Hello,

ITPeter :

I am Pete, and I'll be happy to assist with your Excel question.

ITPeter :

To use the Mid function, enter the cell reference, then the character you want to start from, and finally the number of characters you want to retrieve.

ITPeter :

For example, if cell A1 contained abcdefghij and you wanted to retrieve characters 4-6, your formula would be =MID(A1,4,3) and the output for this formula would be def.

ITPeter :

Note that if there are any spaces or symbols in the cell, these will be counted as characters, and may affect the result.

ITPeter :

If you would like me to have a look at any specific problems you are experiencing on a spreadsheet, you can try attaching it here using the paperclip icon, or you can upload it to a filesharing website, eg. www.wikisend.com

Customer: replied 4 years ago.
I know that. :)

There is something going on with the sheet that the results are not showing up. All I see is formula.
If you would like me to have a look at any specific problems you are experiencing on a spreadsheet, you can try attaching it here using the paperclip icon, or you can upload it to a filesharing website, eg. www.wikisend.com
If you upload a file to www.wikisend.com, let me know the file ID# XXXXX I can download it.
Customer: replied 4 years ago.
http://wikisend.com/download/182352/Copy of Debug ERS4 Documents for review.xls
Thanks for that.

I have had a look at the spreadsheet and discovered the problem:
The cells are showing the formula and are not showing the desired output because they are formatted as text.
To fix this, you will need to select the affected cells and change the cell format to General.

If you need any further assistance, just let me know!

Pete.
Customer: replied 4 years ago.
I will have to test it tomorrow and then I will get back to you. Thanks
Customer: replied 4 years ago.
I was able to test it. It works. How did you know what the problem was?
I have seen this type of problem before, so it was the first thing I checked.
Pete and 2 other Microsoft Office Specialists are ready to help you
Customer: replied 4 years ago.
Great. Thanks.