ExcelBanter - splitting text from one cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - splitting text from one cell (https://www.excelbanter.com/excel-discussion-misc-queries/64154-splitting-text-one-cell.html)

rogera

splitting text from one cell

I need to remove specified data from a single cell and place on the same row
in another column. Not all data will be the same eg 100mg, 200mg etc

Bernard Liengme

splitting text from one cell

Not too clear; what data?
Do you want to extract the number from the text?
This will extract 100 from 100mg and 5 from 5mg:
=--LEFT(A1,FIND("m",A1)-1)
Any help?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"rogera" wrote in message
...
I need to remove specified data from a single cell and place on the same
row
in another column. Not all data will be the same eg 100mg, 200mg etc

All times are GMT +1. The time now is 05:10 AM.