Hi all,
Please, I need to have a ( formula ) in cell H5 to display numbers only with same format, but (without USD) text
Please see attached worksheet
Kind regards,
Adel
Hi all,
Please, I need to have a ( formula ) in cell H5 to display numbers only with same format, but (without USD) text
Please see attached worksheet
Kind regards,
Adel
Try this in your cell H5 (not sure about international number formats).
=LEFT(Table_0[@Column5],LEN(Table_0[@Column5])-4)*1
or this:
=MID(Table_0[@Column5],1,SEARCH(" ",Table_0[@Column5])-1)*1
thank you dear. I worked fine
Regards
Thanks for the positive feedback, glad having been of some help.
Hi, all
I have a table in attached worksheet. I need to find the address of web site that this table is linked to
Regards
Adel
Hi all,
I am trying to locate the command to create a thread.
Any help please
Regards,
Adel
Click "Forum" in the menu bar on the top of this page or click "Forum" in the menu bar just under the OzGrid logo.
An alternative is with Power Query
let
Source = Excel.CurrentWorkbook(){[Name="Table_0"]}[Content],
#"Extracted Text Before Delimiter" = Table.TransformColumns(Source, {{"Column4", each Text.BeforeDelimiter(_, " "), type text}, {"Column5", each Text.BeforeDelimiter(_, " "), type text}, {"Column6", each Text.BeforeDelimiter(_, " "), type text}})
in
#"Extracted Text Before Delimiter"
Don’t have an account yet? Register yourself now and be a part of our community!