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
