98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training company borough high street london - Separating numbers and text
microsoft excel training company borough high street london - Separating numbers and text
Resolved · Low Priority · Version Standard
Elizabeth has attended:
Excel Intermediate course
Excel Advanced course
Separating numbers and text
When importing data from a non-Excel source you can sometimes end up with numbers and text in the same cell. How do you separate numbers and text into different cells so calculations can be performed on the data?
Thanks
RE: Separating numbers and text
Hi Elizabeth
Could you clarify whether the data in the non excel source has the numbers separated, or whether the data is combined during the import process.
If the data is seperated, how is it separated? Does it use commas as in a list or is it in some form of table?
RE: Separating numbers and text
Hi,
It is imported via a CSV format from a table in the web page. However, the table doesn't seem to have comma separation.
Thanks for your help,
Elizabeth
RE: Separating numbers and text
Hi Elizabeth
I really need to see the data to be able to help
If it is on the internet could you email me the link, or if if is on an intranet could you email me a copy of the html page and I'll have a look .
My email is stephen@stl-training.co.uk
Regards
Stephen
Training information:
- Microsoft excel training company borough high street london
- Excel course london
- Microsoft Excel Training
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Working with 3D formulasYou can only use fill-down if you remove $ for Absolute References. |