Get instant live expert help on I need help with excel text function format codes

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have an excel table that has 6100 zip codes. I want to use a vlookup function to search for a specific zip code and then deliver a numeric factor result. Zip codes are closer to text than number, but the resulting factor is a number. I can't get the vlookup to work using the proper formatting. Help.
Solved by X. Q. in 22 mins
I am using the excel count if function to look up job codes in a particular column and calculate how many employees we have under that job code. If a code is for example D011 it deletes out the 0 to make it D11 for the function, meaning it does not pull the correct job codes. Help
Solved by E. F. in 25 mins
I have a column of zip codes that are of type "special". I would like to format them as type "text" but when I try to do that the leading zeros are being dropped. Is there a way to do this? Thanks!
Solved by A. L. in 22 mins
How to format text in cells where it doesn't wrap text midword, it wraps complete words?
Solved by V. Q. in 29 mins
In the "data1" spreadsheet, using the appropriate function, complete column E with the full names of the provinces. Codes corresponding to the province names are entered in column D. The codes correspond to the provinces as follows: Code Nom complet NB Nouveau-Brunswick QC Qubec ON Ontario
Solved by M. H. in 27 mins